These fact tables are uniformly dense in their foreign keys because even if no activity takes place during the period, a row is typically inserted in the fact table containing a zero or null for each fact.
- Chapter 2: Kimball Dimensional Modeling Techniques Overview
- from The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition
- Publisher: John Wiley & Sons
- Released: July 2013
Interesting difference with atomic transaction facts.
Share this highlighthttp://www.safaribooksonline.com/a/the-data-warehouse/16751031/