List of Tables

Chapter 1: Basic Components

Table 1.1: A sample row from the fact table

Table 1.2: The related row in the customer dim table

Table 1.3: The related row in the product_dim table

Table 1.4: The related row in the date dim table

Table 1.5: The related row in the order_dim table

Chapter 2: Dimension History

Table 2.1: The customer_dim table before changes are applied

Table 2.2: The revised customer details

Chapter 7: Initial Population

Table 7.1: Your data warehouse’s data sources

Chapter 8: Regular Population

Table 8.1: Data sources and loading types of regular population

Chapter 15: Dimension Hierarchies

Table 15.1: Hierarchies in customer_dim, product_dim, and date_dim

Chapter 16: Multi-Path and Ragged Hierarchies

Table 16.1: 2005 Campaign Sessions

Chapter 24: Accumulated Measures

Table 24.1: Month end balance prepared data

Chapter 25: Band Dimensions

Table 25.1: Marketing segment bands

Appendix A: Flat File Data Sources

Table B.1: Flat files data sources and usage instructions