Fact Table Design Patterns(FTDP): The Essential Building Blocks of Analytical Data Models
Transaction Fact Tables – Recording individual business events
Periodic Snapshot Fact Tables – Regular status snapshots (e.g., monthly balances)
Accumulating Snapshot Fact Tables – Following processes with multiple milestones
Factless Fact Tables – Recording events without measures
Aggregate Fact Tables – Pre-summarized for performance
