Incremental Load

[prma7799]

Hi All,

I have one table called "GL Entry " i wanted to apply incremental logic on it and EntryNo has unique key.

Can anyone explain me how to apply incremental logic for Insert and update .

Thanks

[shraddha_g · Accepted solution]

if you have stored one time data into qvd then you can get Max(EntryNo) from that Qvd

MaxDate:

Load

Max(EntryNo) as LastUpdatedEntry

from......PreviouslyLoaded.qvd

(qvd);

Let vEntry = num(num#(peek('LastUpdatedEntry')));

OracleNewData:

Sql Select *

From ..Source

Where EntryNo > $(vEntry) ;  // Here EntryNo format should match with the one with the Oracle EntryNo field

[prma7799]

I thing this logic useful for only insert how to apply logic for UPDATE

[shraddha_g]

MaxDate:

Load

Max(EntryNo) as LastUpdatedEntry

from......PreviouslyLoaded.qvd

(qvd);

Let vEntry = num(num#(peek('LastUpdatedEntry')));

OracleNewData:

Sql Select *

From ..Source

Where EntryNo > $(vEntry) ;

Concatenate

Load *

From PreviouslyLoaded.qvd

Where not exists(EntryNo,EntryNo)  

;

Store OracleNewData into PreviouslyLoadedQvd;