Fact Table and Dimension Table
1 min readSep 30, 2019
Fact Table:-
Fact Table is a central table in a star schema or snowflake schema of a data warehouse.
Fact tables data in number format.
The fact table is used for analysis and reporting.
Primary Key in fact table is mapped as foreign keys to Dimensions.
Dimension Table:-
Dimension Table connected to the fact table.
Dimensional table data is in string format.
It is located at the edge of a star schema or snowflake schema.
The foreign key is mapped to the facts table.
If you are new to MSBI start with the following must-watch video: -