0 votes
in Dataware house by
What is the difference between ER Modeling and Dimensional Modeling?

1 Answer

0 votes
by

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.

Related questions

0 votes
asked Jan 27 in PowerBI by GeorgeBell
0 votes
asked Oct 20, 2019 in Dataware house by rajeshsharma
...