One of the furious debates in the field of data warehousing pertains to the DW planning and development approach. The two “forefathers” of data warehousing, Bill Inmon and Ralph Kimball have different takes on the process (also known as the “Inmon vs. Kimball” debate). Here is a short summary of their views: (1) Top-down approach (The Inmon’s approach – not in the textbook we use) DW is developed based on a complete Enterprise wide data model- i.e., need to consider all potential dimensions, data sources, etc. and integrate disparate data sources. DW is a single large organizational repository that feeds data into departmental data marts (2) Bottom-up approach (The Kimball’s app
One of the furious debates in the field of data warehousing pertains to the DW planning and development approach. The two “forefathers” of data warehousing, Bill Inmon and Ralph Kimball have different takes on the process (also known as the “Inmon vs. Kimball” debate). Here is a short summary of their views: (1) Top-down approach … Read more