Issue in Change capture stage

[hsahay]

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.

[Kryt0n]

Have you tried running on a single node?

If all looks good on a single node, your partitioning is wrong. If still a problem, then likely your selection of existing records is wrong

[dspxlearn]

As Kryt0n said, your partitioning on the input links of the change capture stage might be wrong.
Try to hash partition on the key cloumns on both the input links and see..

Let us know the result.