RDBMS-DW ASSIGNMENT
PART-III
CHAPTER-10
10.1: Adding new columns to the customer dimension
10.2: Adding the order_quantity column
10.3: Revised daily DW regular population
10.4: Adding the order_quantity column to the sales_order table
10.4: Adding the order_quantity column to the sales_order table
10.5: Adding nine sales orders with order quantities
Sales_Order table
CHAPTER-11
11.1: Promotion indicator
11.2: Populating the promotion indicator
11.3:
Creating the promotion staging table
CHAPTER-12
12.1: Implementing the month roll-up dimension
12.2: The revised date pre-population script
Query the month_dim to confirm correct population
12.5: The revised daily DW regular population
12.6: Adding two customers
CHAPTER-13
13.1: Adding the request_delivery_date_sk column
13.2: The revised daily DW regular population
13.3: Adding the request_delivery_date column to the sales_order table
13.4: Adding three sales orders with request delivery dates
13.5: Daily sales summary
13.6: Creating date views
13.7: Database view role playing
CHAPTER-14
14.1: Creating monthly_sales_order_fact
14.2: Populating month_end_sales_order_fact
14.3: Modifying the sales order table
14.7: Adding two sales orders
14.8: Adding three sales orders with Allocate and/or Packing
dates
14.9: Sales orders with Allocate and/or Packing dates
.png)
.png)
