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:
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