Well!! A fact table is always DENORMALISED table. It consists of data from dimension table (Primary Key's) and Fact table has Foreign keys and measures.
the main funda of DW is de-normalizing the data for faster access by the reporting tool...so if ur building a DW ..90% it has to be de-normalized and off course the fact table has to be de normalized...
the fact table is always DE-NORMALIZED.somebody answered it as normalized.See if u dont know the answers plz dont post them.Just dont make lottery by posting wrong answers.
I read the above comments. I confused. then we should ask Kimball know. Here is the comment..
FableAugust 3, 2005 Dimensional models are fully denormalized. Fact Dimensional models combine normalized and denormalized table structures. The dimension tables of descriptive information are highly denormalized with detailed and hierarchical roll-up attributes in the same table. Meanwhile, the fact tables with performance metrics are typically normalized. While we advise against a fully normalized with snowflaked dimension attributes in separate tables (creating blizzard-like conditions for the business user), a single denormalized “big wide table” containing both metrics and descriptions in the same table is also ill-advised.
I am highlighting what Kimball says here: " Dimensional models combine normalized and denormalizedtable structures. The dimension tables of descriptive information are highly denormalized with detailed and hierarchical roll-up attributes in the same table. Meanwhile, the fact tables with performance metrics are typically normalized. While we advise against a fully normalized with snowflaked dimension attributes in separate tables (creating blizzard-like conditions for the business user), a single denormalized “big wide table” containing both metrics and descriptions in the same table is also ill-advised."
