Periodic Snapshot Fact Tables

A row in a periodic snapshot fact table summarizes many measurement events occurring over a standard period, such as a day, a week, or a month. ┬áThe grain is the period, not the individual transaction. ┬áPeriodic snapshot fact tables often contain many facts because any measurement event consistent with the fact table grain is permissible. … Continue reading Periodic Snapshot Fact Tables