Hello QV community,
Today i'm having the following issue :
I have these dimensions :
DIM_REGION (REGION_ID, REGION_CODE,REGION)
DIM_GENDER (GENDER_ID, GENDER_CODE,GENDER)
DIM_GRADE(GRADE_ID, GRADE_CODE, GRADE)
ETC..
I also have this table from where i'm going to load my fact :
TABLE_AGENT (REGION_CODE, GENDER_CODE, GRADE_CODE).
______________
My question is : How to load my fact table (let's call it FACT_TEST)
Which must contains these fields : ID, REGION_ID, GENDER_ID, GRADE_ID and my measures list.
Thanks