Data Warehousing Basics Question:
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.
E-R modeling is used for normalizing the OLTP database design.
Dimensional modeling is used for de-normalizing the ROLAP/MOLAP design.
| Previous Question | Next Question |
| Explain What are the advantages data mining over traditional approaches? | What is a Fact, Dimension, Measure? |