Data Warehousing Question:
Download Job Interview Questions and Answers PDF
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.
Download Data Warehousing Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is conformed fact? | Why fact table is in normal form? |