maintaining a delta load

[Former Member]

hi experts,

when we do a delta load , all the records from the delta queues are loaded in to the data target.

what u do next once u finished a delta load. what happens to the daily transactions which occurs after the delta load. do we have to repeat the delta load again ? if so how can we do it ? please help me

regards

Abhilash Muraleedharan

[edwin_harpino · Accepted solution]

hi Abhilash,

daily transactions will keep go to delta queue,

delta load to bw need to be scheduled daily, normally in time where no transactions in source system occured, you can use process chain,

schedule the process chain job periodically (daily),

or just schedule the infopackage run background and periodically,

hope this helps.

[Former Member]

Once delta load sucessfully to BW, next delta we will not call as repeat delta.

<b>Repeat delta</b> : if the delta load fail, the same delta you want load once again that is called repeat delta.

MSR

[Former Member]

Hi,

You need to understand the Update methods avialable incase of LO data sources.

Depending upon the Update method the new/modified records will be collected immediately in the intermediate place(for ex : Extraction queue,QRFC,..). And we need to run (not in all cases) collective run reqularly to move this records to RSA7 from which the Infopackage scheduling can pull the data. So here also we need to execute the infopackage jobs periodically and this starting has to be occured after the collective run is over.

With rgds,

Anil Kumar Sharma .P

[Former Member]

HI

Abhilash

Once the delta is done the system will mark the records as successfully loaded.

the new or changed records which will be created be collected for the next delta load.

hope this helps