Explain Difference between E-R Modeling and Dimentional Modeling?
Submitted by: AdministratorBasic 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.
Submitted by: Administrator
E-R modeling is used for normalizing the OLTP database design.
Dimensional modeling is used for de-normalizing the ROLAP/MOLAP design.
Submitted by: Administrator
Read Online Data Warehousing Basics Job Interview Questions And Answers
Top Data Warehousing Basics Questions
☺ | Explain the definition of normalized and denormalized view and what are the differences between them? |
☺ | Explain degenerate dimension table? |
☺ | What is the main difference between schema in RDBMS and schemas in DataWarehouse? |
☺ | What are the Data Marts? |
☺ | Explain Differences between star and snowflake schemas? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |