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.