| January 01, 2008 01:10:14 |
#2 |
| ersaurabhex |
Member Since: January 2008 Total Comments: 1 |
RE: “A dimension table is wide but the fact table is deep” Explain the statement in your own words.
|
A dimension table contains a higher granular information so have less no of records and it needs to have all the necessary details (More columns) related to the grain of the table. On the other side, A fact table has the lowest level grain of a subject area. Lower grain cause more number of rows in the Fact table.
|
| |
