Ask
Login
0
2.9kviews
Differentiate between E-R modeling and Dimensional modeling.
written 3.6 years ago by gravatar for pradnyanabar2613 pradnyanabar2613 ★ 5.2k modified 3.6 years ago by gravatar for Krishna_Agrawal Krishna_Agrawal • 2.7k
data warehouse and mining
ADD COMMENT EDIT
1 Answer
0
174views
written 3.6 years ago by gravatar for Krishna_Agrawal 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 …

Create a free account to keep reading this post.

and 2 others joined a min ago.

ADD COMMENT EDIT
Please log in to add an answer.