we are using change capture to find the new/update and deleted records.
After the first run, it gave x number of records for insert and y number of records for update.
We ran the update job which updates the records and load job which loads the new records.
When we try to run the change capture job with same input data as first, we were expecting that there should not be any inserts/updates as we updated/loaded the table with change records.But it is still giving the same number of x insert records an y number of updates as in first run.
We are using the 3 keys and about 45 change values.
when We checked everything looks fine but still there is no change in the output.
please help us in this regard.
Thanks in advance.
Issue in Change capture stage
Moderators: chulett, rschirm, roy