Change capture stage insert issue

[dspxlearn]

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?

[richdhan]

Hi,

Did you check the link ordering in the CDC stage. The source should be the after link.

HTH
--Rich

[Kryt0n]

Would have to be the correct link otherwise the output would be a delete rather than insert...

Try on a single node or ensure you partition by the key