Data Warehouse Design
Data Warehouse Design
Learning data warehouse design is actually learning data modeling.
A very common approach of designing the data warehouse is Dimensional Modeling.
Typical artifact in data warehouse model
Here are the design patterns or tips I identified after studying the various books and reviewing the data warehouses.
Design Tip: Key for the Date Dimension
Design Tip: Use minidimension to handle rapidly changing monster dimension