How can you say Relational is Normalized one and Data Warehouse i.e Dimensional modeling is De-Normalized one when both model follows the Primary Key Concept in its table to store Data

Iftikhar Alam

• Apr 8th, 2012

Data obtain from transactional source which is normalized on 3NF. It has been staged and demoralized the data and after denationalization of data re-normalized on 2NF and 3NF. Therefore, It is called Demoralized but it is normalized not like the transactional

madhavig

 Profile Answers by madhavig Questions by madhavig

• Feb 16th, 2010

Dimensional modeling usually does with 2NF for dimensions and 3NF for facts.Dimensions are de-normalized for better query performance and for better understanding by business users.

Answer Question  Select Best Answer