concatenation of multiple fact table??

[sushil353]

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.

[sushil353]

Please share your experience...

[Jason_Michaelides]

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