Change Data Capture

[nima511]

I am using the Change Data Capture stage to perform comparisons for the below 2 inputs and am getting different number of records for each run. For e.g. I get 2 records or 3 or 1 record as output when I run each time: Can some one please help me as to why this is happening.
Thank you
Input 1
Key id_no LName FName
1 123 Phil Ken
1 000 Phil Adam
2 000 Brann Mary
3 000 Brown Sam

Input 2
Key id_no LName FName
1 000 Phil Ken
1 000 Phil Adam
2 000 Brann Mary
3 000 Brown Sam

[chulett]

How many nodes? How are you partitioning in your job? Is it consistent if you run on one node?

[nima511]

I am running on 2 nodes and am using the Auto Partition.

[chulett]

And? Three questions, two answers, one big hint.