RDBMS-DW ASSIGNMENT

PART-II

CHAPTER-5

5.1: Push CDC sales orders

5.2: Creating the sales_order table

5.3: Data for testing Push mode

CHAPTER-6

6.1: Stored procedure to pre-populate the date dimension

Testing Pre-Population

Query first five data:

Query last five data:

 6.2: Daily date population

6.3: Loading dates from the source

6.4: Adding more dates from additional sales orders

CHAPTER-7

7.1: DW initial population (Each of 6 steps described below)

7.2: Script for truncating the tables

7.3: Sales orders for testing initial population

7.4: Query to confirm the sales orders are loaded correctly

CHAPTER-8

8.1: Daily dw regular population

8.2: Adding sales orders