Fact Table and Dimension Table

Pooja Patil
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.

Fact Table and Dimension Table

If you are new to MSBI start with the following must-watch video: -

--

--