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