Tell us what is the main difference between Inmon and Kimball philosophies of data warehousing?
Submitted by: MuhammadBoth differ in the concept of building the data warehouse.
☛ Kimball views data warehousing as a constituency of Data marts. Data marts are focused on delivering business objectives for departments in the organization. And the data warehouse is a conformed dimension of the data marts. Hence, a unified view of the enterprise can be obtained from the dimension modeling on a local departmental level.
☛ Inmon explains in creating a data warehouse on a subject-by-subject area basis. Hence, the development of the data warehouse can start with data from the online store. Other subject areas can be added to the data warehouse as their needs arise. Point-of-sale (POS) data can be added later if management decides it is necessary.
☛ Hence, Kimball–First Data Marts–Combined way -Data warehouse
☛ Inmon-First Data warehouse–Later--Data marts
Submitted by: Muhammad
☛ Kimball views data warehousing as a constituency of Data marts. Data marts are focused on delivering business objectives for departments in the organization. And the data warehouse is a conformed dimension of the data marts. Hence, a unified view of the enterprise can be obtained from the dimension modeling on a local departmental level.
☛ Inmon explains in creating a data warehouse on a subject-by-subject area basis. Hence, the development of the data warehouse can start with data from the online store. Other subject areas can be added to the data warehouse as their needs arise. Point-of-sale (POS) data can be added later if management decides it is necessary.
☛ Hence, Kimball–First Data Marts–Combined way -Data warehouse
☛ Inmon-First Data warehouse–Later--Data marts
Submitted by: Muhammad
Read Online Data Warehouse Developer Job Interview Questions And Answers
Top Data Warehouse Developer Questions
☺ | Explain me why is chameleon method used in data warehousing? |
☺ | Tell us what is Hybrid SCD? |
☺ | Tell us what is the main difference between Inmon and Kimball philosophies of data warehousing? |
☺ | Can you list the Schema that a data warehouse system can implements? |
☺ | Tell us what is Virtual Warehouse? |
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. |