Part III: Growth

Chapter List

Chapter 10: Adding Columns

Chapter 11: On-Demand Population

Chapter 12: Subset Dimensions

Chapter 13: Dimension Role Playing

Chapter 14: Snapshots

Chapter 15: Dimension Hierarchies

Chapter 16: Multi-Path and Ragged Hierarchies

Chapter 17: Degenerate Dimensions

Chapter 18: Junk Dimensions

Chapter 19: Multi-Star Schemas

Part Overview

If your starter data warehouse is successful, your users will want more. They may ask you to load more data to the data warehouse. By then, you should be prepared for growth.

Part III discusses how you can extend your data warehouse by

• adding columns and tables

• splitting dimensions

• using dimensions differently and for special purpose

• adding a derived star and a whole new star