Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have three fact table. i want to concatenate them and create a qvd file with incremental load.. please help me how to do it..
Please have a look the tables shown below.. All the dimensions are common to all three fact tables..
Thanks.
Please share your experience...
Hi - try this:
FACT:
LOAD
'Source1' AS FACT_Type,
*
FROM Source1....;
CONCATENATE (FACT)
LOAD
'Source2' AS FACT_Type,
*
FROM Source2....;
CONCATENATE (FACT)
LOAD
'Source3' AS FACT_Type,
*
FROM Source3....;
STORE FACT INTO FACT.qvd;
Then, on your incremental load (S_ORIG_CODE is a unique identifier):
FACT:
LOAD * FROM FACT.qvd;
CONCATENATE (FACT)
LOAD
'Source1' AS FACT_Type,
*
FROM Source1....
WHERE NOT EXISTS(S_ORIG_CODE);
CONCATENATE (FACT)
LOAD
'Source2' AS FACT_Type,
*
FROM Source2....
WHERE NOT EXISTS(S_ORIG_CODE);
CONCATENATE (FACT)
LOAD
'Source3' AS FACT_Type,
*
FROM Source3....
WHERE NOT EXISTS(S_ORIG_CODE);
STORE FACT INTO FACT.qvd;
Hope this helps,
Jason