LOADING FACT TABLE FOR RETAIL DOMAIN

 

FACT TABLE LOADING CONCEPT:

DOMAIN USED : RETAIL

SOURCE TABLE NAME :  POS

DATES USED: 24 AND 25 JUL 2012

LOADING  PRODUCT DIMENSION:

RETRIEVING ONLY DISTINCT RECORDS FOR THE PRODUCT DIMENSION:

LOADING  STORE DIMENSION:

LOADING  LOCATION DIMENSION:

 

LOADING  DATE DIMENSION:

LESSON LEARNT: DATE WAS GIVEN DATE DATATYPE WHILE CREATING THE TABLE BUT THAT WAS TAKEN AS STRING.SO WHILE INSERTING HAD TO USE TO_DATE(SYSDATE,’DD-MON-YY’) SO AS TO CONVERT TO A DATE.

AGGREGATING BASED ON ALL FORIGNKEYS IN FACT TABLE ANS SUM() ON QTY_SOLD:

FACT TABLE LOADING  BY LOOKING UP ON ALL DIMENSIONS AND AGGREGATING THEM:

 DATA PREVIEW IN FACT TABLE:

FACT TABLE RESULTS: