Fact table overview
A fact table is the central table in a star schema of a data warehouse. A fact
table has two types of columns:
- Columns that contain numeric facts (often called measurements)
- Columnsthat are foreign keys to dimension tables
Fact Table definitions load fact records into the data mart and assign all necessary dimension keys.
Note:
Similar to Dimension tables, you can apply trace columns to fact records.