changes in record sequence during delta load
We have a custom extractor to load pricing condition records to BI.
We are writing the delta through BTE directly to the delta
queue. The inserts, updates & deletes of the records for that specific transaction are in right order in the delta queue in the source system and in PSA when extracted in BI. But we run the DTP, the record sequence is changed from the original order and hence the record updates doesn't happen correctly in BI. The delta process for the data source is AIM. Please provide your inputs on this.