Partial Reload Question

[#1]

Hi Folks

I have a question on using Partial Reload that you might be able to help me with.

I have a document that loads a very large (100m rows, 180 columns) QVD file, and after loading the master file (re-built daily) it then loads a series of much smaller (in terms of rows) files that are generated throughout the day.  My question is, can I use a partial reload so that only the smaller files are added throughout the day?

Script currently:

TRADE_FACT:

LOAD * FROM Trade_Data.QVD;

LOAD * FROM Trade_Incremental_Data_*.QVD;

I am wondering if you think the following would work:

TRADE_FACT:

LOAD * FROM Trade_Data.QVD;

REPLACE LOAD * FROM Trade_Incremental_Data_*.QVD;

If this won't work, do you have any suggestions as to how this incremental load could be done.

Thanks,

Nigel.

[#2 · Accepted solution]

Instead of "Replace" you can use "Add"..

Karthik

[#3]

Hi

Pls Check...

set vLoadType = 'Delta';

If vLoadType = 'Delta' then

    If NoOfRows(TRADE_FACT) > 0 then

      Store TRADE_FACT into DeltaTRADE_FACT.qvd;  

Else
     Store TRADE_FACT into TRADE_FACT.qvd;  

Regards-Bika