Dear BW experts:
I faced an issue in one amdp transformation. When executing delta loading, some record sequence are disordered.
The involved amdp tr has an end routine, which is quite simple, inner joins two tables
to be specific, the delta data in source ADSO changelog table are below:
as it shows, the latest correct status is 04,
however, when executing delta loading with amdp TR, some record sequence is disordered, like below data framed by red, the 01 state goes to the last record, which leads to an error status after activating data
it's quite odd that only certain records have this issue, not all the records. I tried to change the package size and set the dtp extraction group, but neither of them works.
Any ideas on how to avoid this issue?
Thanks in advance