Transaction Fact Table
One row per sale, payment, or click, at the finest grain the process records. Transaction fact tables answer “what happened” directly; state takes more work.
-
-
Periodic Snapshot Fact Table
A periodic snapshot stores the state of every account or product once per day or month, including quiet ones, so “what was it then” becomes a simple read.
-
Data Modeling for OLTP and OLAP Systems
How row meaning, identity, dependencies, aggregation, and time shape operational and analytical data models.