Enterprise Data Warehouse Question:

Download Job Interview Questions and Answers PDF

Explain the main difference between Inmon and Kimball philosophies of data warehousing?

Enterprise Data Warehouse Interview Question
Enterprise Data Warehouse Interview Question

Answer:

Both differed in the concept of building the data warehouse.According to Kimball, 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 beliefs 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.

Download Enterprise Data Warehouse Interview Questions And Answers PDF

Previous QuestionNext Question
Explain difference between view and materialized view?Why fact table is in a normal form?