Categories

Oct 20, 2019 in Dataware house

Q: What is the difference between ER Modeling and Dimensional Modeling?

1 Answer

Oct 20, 2019

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.

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

Madanswer
Oct 20, 2019 in Dataware house
Oct 27, 2019 in DBMS
Oct 7 in Ansible
...