Hi,
I came across a scenario while doing the delta between previous data and current data. In previous data, i just have one record and in my current data, i have an updated record and a copy of the record which is already there is previous data.
When, i do a delta, i should get only one update. But, i am getting one insert as well.
Seems, the update record on current data is matching with the only existing record on previous record and getting the change code as 3(which is update). The other copy record form the current record is not finding a record on the previous data and so, it is coming as an insert with change code 1.
Could anyone help me how this situation to be handled?
Change capture stage insert issue
Moderators: chulett, rschirm, roy
Change capture stage insert issue
Thanks and Regards!!
dspxlearn
dspxlearn