chapter 1:
Q1 : Creating data warehouse tables
Q2 : Generating customer surrogate key values
Q3: Inserting more customers
chapter 2:
Q1: Applying SCD1 to the customer names in customer_dim
Q2: Creating and loading the customer_stg table
Q3 : Applying SCD2 to product_name and product_category in the product_dim table
Q4: Loading products to its staging table
chapter 3
chapter 4 :
chapter 6 :
Stored procedure to pre-populate the date dimension
chapter 7 :
DW initial population
Script for truncating the tables
chapter 8 :
Daily dw regular population
chapter 11:
chapter 12 :
chapter 13:
Q1 : Creating data warehouse tables
Q2 : Generating customer surrogate key values
Q3: Inserting more customers
chapter 2:
Q1: Applying SCD1 to the customer names in customer_dim
Q2: Creating and loading the customer_stg table
Q3 : Applying SCD2 to product_name and product_category in the product_dim table
Q4: Loading products to its staging table
chapter 3
Testing
Fully-Additivity
chapter 4 :
Applying Dimensional
Queries
chapter 5 :
chapter 6 :
Stored procedure to pre-populate the date dimension
DW initial population
Script for truncating the tables
chapter 8 :
Daily dw regular population
chapter 10 :
Revising
Regular Population Script
chapter 11:
On-Demand Population
chapter 12 :
Subset Dimensions
chapter 13:
Dimension Role Playing
