Data Warehousing Question:
What is Difference between E-R Modeling and Dimensional Modeling?
Answer:
Basic difference 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.
| Previous Question | Next Question |
| What is conformed fact? | Why fact table is in normal form? |