Bottom up approach
Sales
fact table with measures like TotalSales
and QuantitySold
.Customer
dimension table with attributes like CustomerID
, Name
, and City
.Sales
fact table connected to Customer
, Product
, and Time
dimension tables.CustomerID
surrogate key in the Customer
dimension table.Time
dimension table used by both Sales
and Inventory
fact tables.Aspect | Kimball Approach | Inmon Approach |
---|---|---|
Design Philosophy | Bottom-up, iterative development. | Top-down, centralized data warehouse. |
Model Type | Dimensional modeling (star schema). | Normalized modeling (3NF). |
Focus | Business user needs and query performance. | Data integration and consistency. |
Development | Iterative and incremental. | Big-bang, centralized. |
Complexity | Simpler, easier to understand. | More complex, requires expertise. |