topic concatenation of multiple fact table?? in QlikView

concatenation of multiple fact table??

sushil353 — Mon, 19 Sep 2011 09:49:37 GMT

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 — Mon, 19 Sep 2011 11:35:59 GMT

Please share your experience...

Jason_Michaelides — Mon, 19 Sep 2011 18:08:45 GMT

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