|
Answer» The record of a reality or fact table could be made up of attributes from various dimension tables. The Fact Table, also known as the Reality Table, assists the user in investigating the business aspects that aid him in call taking in order to improve his FIRM. Dimension Tables, on the other hand, make it easier for the reality table or fact table to collect dimensions from which measurements must be taken. The following table enlists the difference between a fact table and a dimension table:- | Fact Table | Dimension Table |
|---|
| It contains the attributes' measurements, facts, or metrics. | It is the companion table that has the attributes that the fact table USES to derive the facts. | | DATA grain (the most atomic level by which facts may be defined) is what defines it. | It is detailed, comprehensive, and lengthy. | | It is used for analysis and decision-making and contains measures. | It contains information regarding a company's operations and procedures. | | It contains information in both numeric and textual formats. | It only contains textual information. | | It has a primary key that works as a FOREIGN key in the dimension table. | It has a foreign key that is linked to the fact table's primary key. | | It stores the filter domain and REPORTS labels in dimension tables. | It organizes the atomic data into dimensional structures. | | It does not have a hierarchy. | It has a hierarchy. | | It has lesser attributes than a dimension table. | It has more attributes than a fact table. | | It has more records as compared to a dimension table. | It has fewer records than a fact table. | | Here, the table grows vertically. | Here, the table grows horizontally. | | It is created after the corresponding dimension table has been created. | It is created prior to the creation of the fact table. |
|
