What is Difference between E-R Modeling and Dimensional Modeling?
Submitted by: AdministratorBasic difference 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
Submitted by: Administrator
Read Online Data Warehousing Job Interview Questions And Answers
Top Data Warehousing Questions
☺ | What is the difference between aggregate table and materialized view? |
☺ | "A dimension table is wide but the fact table is deep," Explain the statement in your own words. |
☺ | What is the advantages data mining over traditional approaches? |
☺ | What are data validation strategies for data mart validation after loading process? |
☺ | Can you pass sql queries in filter transformation? |
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. |