0

2.9kviews

Differentiate between E-R modeling and Dimensional modeling.

written 3.6 years ago by bhaskar12082000 • 0

modified 3.6 years ago by yerasylmakulbe671 • 10

data warehouse and mining

ADD COMMENT FOLLOW SHARE EDIT

1 Answer

0

174views

written 3.6 years ago by yerasylmakulbe671 • 10

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