Incremental load

[deepakqlikview_123]

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

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