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:
