Incremental load

deepakqlikview_123 — Mon, 26 May 2014 07:06:28 GMT

========================================================

LET vDeltaBegins=Timestamp(Now(1),'YYYY-MM-DD hh:mm:ss');

DELTA_PSA:

LOAD

SERIES,

LastTime,

LoadType,

LoadScript,

TotalReloadTime

FROM $(QvdPath)\DELTA_PSA.QVD (Qvd);

DELTA_PSA1:

LOAD

MAX(SERIES) AS LastSeriesNo

RESIDENT DELTA_PSA;

DELTA_PSA2:

LOAD

Timestamp(MAX(LastTime),'YYYY-MM-DD hh:mm:ss') AS LastReloadTime

RESIDENT DELTA_PSA;

//where LoadScript='$(VPARAM)';

LET vLastSeriesNo=peek('LastSeriesNo',-1,'DELTA_PSA1');

LET vLastSeriesNo=$(vLastSeriesNo)+1;

LET vLastReloadTime=TIMESTAMP(PEEK('LastReloadTime',-1,'DELTA_PSA2'),'YYYY-MM-DD hh:mm:ss');

LET vLoadScript='$(VPARAM)';

DROP TABLE DELTA_PSA,DELTA_PSA1,DELTA_PSA2;

Hi All,

Can u plz tell me what is the use of delta load in above case.

thanks

topic Incremental load in QlikView