Data Warehousing Basics Question:
Download Questions PDF

Explain Difference between E-R Modeling and Dimentional Modeling?

Answer:

Basic diff is E-R modeling will have logical and physical model. Dimensional model will have only physical model.

E-R modeling is used for normalizing the OLTP database design.

Dimensional modeling is used for de-normalizing the ROLAP/MOLAP design.

Download Basics Data Warehouse Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What are the advantages data mining over traditional approaches?What is a Fact, Dimension, Measure?