Question - What’s the biggest difference between Inmon and Kimball philosophies of knowledge warehousing?
Answer -
These are two philosophies that we’ve in data warehousing. Within the Kimball philosophy, data warehousing is viewed as a constituency of knowledge mods, so data mods are focused on delivering business objectives for departments in a corporation, and therefore the data warehouse may be a confirmed dimension of the info mods hence a unified view of the enterprise are often obtained from the dimension modeling on a departmental area level, and within the Inmon philosophy we will create a knowledge warehouse on a topic by discipline basis hence the event of the info warehouse can start with the info from the web store other subject areas are often added to the info warehouse as their need arises point of sale or pos data are often added later if management decides that it’s required and if we check it out on a kind of algorithmic basis within the Kimball philosophy we first accompany data marts then we combine it and that we get our data warehouse while with Inmon philosophy we first create our data warehouse then we create our data marts.
Both differ within the concept of building the info Warehouse. – Kimball views Data Warehousing as a constituency of knowledge marts. Data marts are focused on delivering business objectives for departments in a corporation, and therefore the Data Warehouse may be a conformed dimension of the info Marts. Hence, a unified view of the enterprise is often obtained from the dimension modeling on a departmental area level. – Inmon explains in creating a knowledge Warehouse on a subject-by-subject area basis. Hence, the event of the info Warehouse can start with data from the web store. Other subject areas are often added to the info Warehouse as their needs arise. Point-of-sale (POS) data is often added later if management decides that it’s necessary.