A reality or fact table’s record could be a combination of attributes from totally different dimension tables. The Fact Table or Reality Table helps the user to investigate the business dimensions that helps him in call taking to enhance his business.
On the opposite hands, Dimension Tables facilitate reality table or fact table to gather dimensions on that the measures needs to be taken.
The main difference between fact table or reality table and Dimension table is that, dimension table contains attributes on that measures are taken actually table.
Difference between Fact Table and Dimension Table:
|S.NO||Fact Table||Dimension Table|
|1.||Fact table contains the measuring on the attributes of a dimension table.||Dimension table contains the attributes on that truth table calculates the metric.|
|2.||In fact table, There is less attributes than dimension table.||While in dimension table, There is more attributes than fact table.|
|3.||In fact table, There is more records than dimension table.||While in dimension table, There is less records than dimension table.|
|4.||Fact table forms a vertical table.||While dimension table forms a horizontal table.|
|5.||The attribute format of fact table is in numerical format and text format.||While the attribute format of dimension table is in text format.|
|6.||It comes after dimension table.||While it comes before fact table.|
|7.||The number of fact table is less than dimension table in a schema.||While the number of dimension is more than fact table in a schema.|
- Hash Table vs STL Map
- Program for IP forwarding table lookup
- Difference between LAN, MAN and WAN
- Difference between TDM and FDM
- Difference between PNG and GIF
- Web 1.0, Web 2.0 and Web 3.0 with their difference
- Difference between CRT and LCD
- Difference between MAN and WAN
- Difference between 1G and 2G
- Difference between LAN and WAN
- What's difference between MMU and MPU?
- Difference Between SEO and SEM
- Difference between LAN and MAN
- Difference between CPU and GPU
- Difference between ++*p, *p++ and *++p
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.