A dimension table is wide but the fact table is deep Explain the statement in your own words.

Showing Answers 1 - 2 of 2 Answers

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.

  Was this answer useful?  Yes

Dimension table has got all the detail informations of their respective table ,for eg, customer dimension table will contain all the related info about customers whereas fact table contains the main data,which contains the surrogate keys of every dimensions  along with other measures.

ramonasiraj

  • Jul 21st, 2008
 

A dimension table contains details about subject area. Eg. customer , product

Fact table contains all business measures ( numeric value) and foreign key value.

  Was this answer useful?  Yes

sraghav20

  • Oct 7th, 2010
 

Visualize it...

You need more lookup data to fit in a single row in dimensions.. Its lookup data, it wont have as many records as the fact, but it would have far more columns. A Visually, if you think of dimension table as a excel sheet, you would be scrolling horizontally to see all the data, thus the phrase, "wide"

On the other hand, The fact stores actual measures, transactional data at the lowest possible granularity.. resulting in far more no of rows. Visually speaking, if you represent a fact table as an excel table it would have too many rows ... making you scroll down.... thus the "deep" phrase.

  Was this answer useful?  Yes

Shaheryar Dilawer

  • Jul 25th, 2017
 

A dimension table consists mainly of descriptive attributes that are textual fields. A dimension table contains a surrogate key, natural key, and a set of attributes. The fact table mainly consists of business facts and foreign keys that refer to primary.

  Was this answer useful?  Yes

Shaheryar Dilawer

  • Jul 25th, 2017
 

Dimension table has to be recorded before the creation of fact table.
The fact table mainly consists of business facts and foreign keys that refer to primary.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions