Key Differences Between Fact Table and Dimension Table

 

Key Differences Between Fact Table and Dimension Table

1.    Fact table contains measurement along the dimension/attributes of a dimension table.

2.    Fact table contains more records and fewer attributes as compared to dimension table whereas, dimension table contain more attributes and fewer records.

3.    The table size of fact table grows vertically whereas, table size of dimension table grows horizontally.

4.    Each dimension table contains a primary key to identify each record in the table whereas, fact table contains concatenated key which is a combination of all primary keys of all dimension table.

5.    Dimension table has to be recorded before the creation of fact table.

6.    A Schema contains fewer fact tables but more dimension tables.

7.    Attributes in fact table are numeric as well as textual, but attributes of dimension table have textual attributes only.