RDBMS-DW ASSIGNMENT

PART-I

CHAPTER-1

1.1: Creating dwid user id

1.2: Creating dw and source databases

    1.3: Creating data warehouse tables

    1.4: Generating customer surrogate key values

 1.5: Inserting more customers

CHAPTER-2

2.2: Creating and loading the customer_stg table

2.1: Applying SCD1 to the customer names in customer_dim

2.4: Creating the product_stg table

      Applying SCD2 to product_name and product_category in the product_dim table

CHAPTER-3

 3.1: Inserting data to demonstrate fully-additive measures

 3.2: Querying across all dimensions

3.3: Querying across the date, product, and order

3.4: Querying across the date, customer, and order

3.5: Querying across the date and order

CHAPTER-4

4.1: Script for that adds data for testing dimensional queries

4.2: Daily Aggregation

4.3: Annual aggregation

4.4: Specific query (monthly storage product sales)

 4.5: Specific query (quarterly sales in Mechanicsburg)

4.6: Inside-out - Monthly Product Performer

4.7: Inside-out (loyal customer)