Data Warehousing - “A dimension table is wide but the fact table is deep” Explain the statement in your own words.

GeekInterview.com > Interview Questions > Data Warehousing

Go To First | Previous Question | Next Question

Data Warehousing | Question 79 of 86

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

Total Answers and Comments: 3

Last Update: February 12, 2008 Asked by: Saba

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

December 06, 2007 07:43:30

VAMSIKRISHNACH

Member Since: December 2007 Contribution: 7

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

Probably they mean dimesion tables will generally have more coloumns where as fact tables will have more rows...

Is this answer useful? Yes | No

January 06, 2008 01:10:14

ersaurabhex

Member Since: January 2008 Contribution: 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.

Is this answer useful? Yes | No

February 12, 2008 21:11:59

Jaycognos

Member Since: November 2007 Contribution: 14

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

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.

Is this answer useful? Yes | No

Go To Top