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

GeekInterview.com > Interview Questions > Data Warehousing

Print |

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

February 02, 2008 21:11:59	#3
Jaycognos	Member Since: November 2007 Total Comments: 13
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.