Data Warehouse Manager Question:

Download Job Interview Questions and Answers PDF

Tell me what is the difference between ER Modeling and Dimensional Modeling?

Warehouse Manager Interview Question
Warehouse Manager Interview Question

Answer:

ER modeling will have logical and physical model but Dimensional modeling will have only Physical model.

ER Modeling is used for normalizing the OLTP database design whereas Dimensional Modeling is used for de-normalizing the ROLAP and MOLAP design.

Download Warehouse Manager Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me what is Execution Plan?Explain me what is Metadata?