Relational and Dimensional Data Modeling

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

Questions by sm_arunachalam

Showing Answers 1 - 4 of 4 Answers

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.

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions