ER Modelling Dimensional Modelling
It supports OLTP It supports OLAP
ER Modelling is always normalized Dimensional Modelling is always denormalized
It removes the redundancy. It permits redundancy.
This model for organization or enterprise is very hard for people to visualize and keep in their heads This model is very easy to understand.
BY Best Interview Question ON 08 Nov 2021