Hi ,
I need to fill a TABLE called “RD_CB_VES_FACT” ( FACT Table ) with the following DIMENSION tables ( ID Field ) as hierarchy :
1) DISTRIBUTOR ( DISTRIBUTOR_ID ) , Using this DISTRIBUTOR_ID I need to Fetch the DIVISION_ID , PLANT_ID and DLY_CALENDAR_ID and under DIVISION_ID we have BRAND and inturn SERIES , similarly under PLANT , PORT and REGION . Now I need to take the ID fields from all these Dimesion tables and fill the FACT Table using a Stored Procedure .
HIERARCHY :
I)
A) DIVISION (DIVISION_ID )
B) BRAND (BRAND_ID)
C) SERIES ( SERIES_ID )
II)
A) PLANT ( PLANT_ID )
B) PORT ( PORT_ID )
C) REGION ( REGION_ID )
III)
A) DLY_CALENDAR ( DLY_CALENDAR_ID )
Please do suggest me a solution asap ... thanks in advance ..
I need to fill a TABLE called “RD_CB_VES_FACT” ( FACT Table ) with the following DIMENSION tables ( ID Field ) as hierarchy :
1) DISTRIBUTOR ( DISTRIBUTOR_ID ) , Using this DISTRIBUTOR_ID I need to Fetch the DIVISION_ID , PLANT_ID and DLY_CALENDAR_ID and under DIVISION_ID we have BRAND and inturn SERIES , similarly under PLANT , PORT and REGION . Now I need to take the ID fields from all these Dimesion tables and fill the FACT Table using a Stored Procedure .
HIERARCHY :
I)
A) DIVISION (DIVISION_ID )
B) BRAND (BRAND_ID)
C) SERIES ( SERIES_ID )
II)
A) PLANT ( PLANT_ID )
B) PORT ( PORT_ID )
C) REGION ( REGION_ID )
III)
A) DLY_CALENDAR ( DLY_CALENDAR_ID )
Please do suggest me a solution asap ... thanks in advance ..
NEED to write a STORED PROCEDURE for the following SITUATION