0
1.3kviews
Differentiate between E-R modeling and Dimensional modeling.
1 Answer
written 2.0 years ago by |
E-R Modeling | Dimensional Modeling |
---|---|
Suitable for Online Line Transaction Processing (OLTP) Application | Suggested for Data Warehousing Applications |
Consists of Entities and Relationships . | Consists of Facts and Dimensions |
High Create/Read/Update/ Delete (CRUD) activity | High Select Activity |
Data Redundancy is not desired | Data Redundancy is desired |
Normalization is suggested | De-Normalization is … |