Chapter 19. Multi-Star Schemas

Starting from Chapter 10, “Adding Columns” you have been growing your data warehouse by adding columns and tables, and in Chapter 14, “Snapshots” you added a second fact table, the month_end_sales_order_fact table. After the addition, your schema has had two fact tables (the first is the sales_order_fact table you created at the start of the data warehouse). With two fact tables, the data warehouse is officially a two-star schema.

In this chapter you will add a new star to the existing stars of the dimensional data warehouse. Unlike the existing stars that are related to sales, the new star addresses the needs of the production business area. The new star, which has one fact table and one dimension table, stores the production data in the data warehouse.