Skip to Content
0
Former Member
Nov 06, 2012 at 05:00 PM

Delta load mechanism

30 Views

Hello All,

I have a DSO1 which is feeding DSO2 as Delta. In the start routine there is lookup for DSO3 where I delete some of the records of source package based on a flag field in DSO3. DSO1, 2 and 3 have the same key fields.


The scenario

01.Nov.2012

There are 15 new records in DSO1. The same 15 records are in DSO3 but the flag is active only for 10 records. So the Delta DTP between DSO1 and DSO2 updated only these 10 records into DSO2. The remaining 5 records were deleted from the source package in the start routine with the look up code.

02.Nov to 05.Nov. - There were similar Delta records been updated to DSO2 like above.

06.Nov.2012

The 5 records that had inactive flag in DSO3 is now updated as active.

Now my question is, will the Delta DTP between DSO1 and DSO2 pickup the records that were not moved to DSO2. I mean will the DTP pickup only the records in the latest request on DSO1 or will it check everytime for all the records in DSO1 which were not updated to DSO2 ?

Thanks,

Suresh