Home
About Us
Contact Us
Bookmark
Saved Bookmarks
Current Affairs
General Knowledge
Chemical Engineering
UPSEE
BSNL
ISRO
BITSAT
Amazon
ORACLE
Verbal Ability
→
MISCELLANEOUS
→
ENGLISH COMPREHENSION in MISCELLANEOUS
→
What is the difference between ER Modelling vs Dim...
1.
What is the difference between ER Modelling vs Dimensional Modelling?
Answer»
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.
Show Answer
Discussion
No Comment Found
Post Comment
Related InterviewSolutions
What is the difference between ER Modelling vs Dimensional Modelling?
What is a real-time data warehouse and what are its benefits?
What is the snowflake schema in the data warehouse?
What are the types of dimensional modeling in data warehouses?
What are the main differences between structured and unstructured data?
What are the steps to build the data warehouse?
Would you like to tell us the difference between Data Warehousing and Data Mining?
What is the difference between various types of data warehousing?
What is data modeling in the data warehouse?
Why do we need a data warehouse instead of a database?
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply
Your experience on this site will be improved by allowing cookies. Read
Cookie Policy
Reject
Allow cookies