What is Difference between E-R Modeling and Dime

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is Difference between E-R Modeling and Dimentional Modeling.?

Basic diff is E-R modeling will have logical and physical model. Dimensional model will have only physical model.

E-R modeling is used for normalizing the OLTP database design.

Dimensional modeling is used for de-normalizing the ROLAP/MOLAP design.

(Continued on next question...)

Other Job Interview Questions

• What is the definition of normalized and denormalized view and what are the differences between them?
• What is the difference between datawarehouse and BI?
• What is a CUBE in datawarehousing concept?
• What is hybrid slowly changing dimension?
• What's the data types present in bo?n what happens if we implement view in the designer n report
• What is ER Diagram?
• What is Dimensional Modelling?
• Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?
• Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?
• Why are OLTP database designs not generally a good idea for a Data Warehouse?
• More...