Srinivas Chaitanya Reddy

• Jul 6th, 2006

 

Flat table is always Normalised since no redundants!!

Srinivas Chaitanya Reddy

• Jul 19th, 2006

 

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.

Thanks!!

fazalhp

• Aug 1st, 2006

 

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...

Hope answer the question...

prasad.yandapalli

• Aug 11th, 2006

 

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.

karthik Kasi

• Aug 21st, 2006

 

Hi,

I read the above comments. I confused. then we should ask Kimball know. Here is the comment..

Fable August 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.

Ref:http://www.kimballgroup.com/html/commentarysub2.html

lakshmi

• Sep 15th, 2006

 

Hi

Dimension tables can be normalized or de-normalized. Facts are always normalized.

Regards

lakshmi1

 Profile Answers by lakshmi1 Questions by lakshmi1

• Sep 15th, 2006

 

Hi

Dimension table can be normalized or de-normalized. But fact table is always normalized

Umesh Singh

• Nov 10th, 2006

 

Dimension table may be normalized or denormalized according to your schema but Fact table always will be denormalized.

Umesh Singh

• Nov 10th, 2006

 

Hi all,

Dimension table may be normalized or denormalized according to your schema but Fact table always will be denormalized.

Regards,

Umesh

BSIL(Mumbai)

lakshmi1

 Profile Answers by lakshmi1 Questions by lakshmi1

• Nov 29th, 2006

 

hi

please see the following site:

http://72.14.253.104/search?q=cache:lkFjt6EmsxMJ:www.kimballgroup.com/html/commentarysub2.html+fact+table+normalized+or+denormalized&hl=en&gl=us&ct=clnk&cd=1

I am highlighting what Kimball says here: " 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."

Regards

lakshmi

Vamshidhar

 Profile Answers by Vamshidhar 

• Jan 6th, 2009

 

Fact tables are always Normalized. 

Where as dimension tables are may be normalized or denormalized.

In Star schema, Fact table is normalized and Dimension table may be normalized or Denormalized.

In Snowflake schema, the Fact table is normalized and Dimension tables are always normalized.

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 13th, 2011

 

Basically the fact tables in both the designs such as star and snowflake schema are normalized

prash

• Apr 15th, 2015

 

FACT table is normalized and dimension table is normalized. please don't confuse. most of the forum answers are wrong

Niranjan

• Apr 22nd, 2015

 

Normalization is splitting 1 table to multiple tables to avoid insert/update and delete anomalies. They are done in OLTP systems. De-normalization is exact opposite of normalization, here multiple tables are joined to form fewer tables. This type of design is used in data warehouse for improving performance of select queries. SO fact table is always denormalized.

sudeep

• Sep 18th, 2015

 

In general Fact table is normalized and Dimension table is denormalized. So that you will get all required information about the fact by joining the dimension in STAR schema. In some cases where dimensions are bulky then we we snowflake it and make it normailzed.