Periodic Fact

Stores current state at regular intervals.

Explain the state of entities at a particular instance in time.

The time interval can be hourly/daily/weekly.

Use Case:

Analyze business performance at a fixed interval.
Status of all flights. 
Inventory stock. How much stock is left at the end of the day?

Transaction Fact Table is the source, and this stores a snapshot of info.

GRAIN for this table will be hourly / 2 hrs / daily based on need.

Last updated