0

1.5kviews

Differentiate between E-R modeling and Dimensional modeling.

written 2.5 years ago by pradnyanabar2613 ★ 5.2k

modified 2.5 years ago by Krishna_Agrawal • 2.7k

data warehouse and mining

ADD COMMENT FOLLOW SHARE EDIT

1 Answer

0

169views

written 2.5 years ago by Krishna_Agrawal • 2.7k

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 suggested

ADD COMMENT SHARE EDIT