Change capture stage insert issue
Posted: Sun Nov 08, 2009 12:04 am
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?
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?