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
Change Data Capture
Moderators: chulett, rschirm, roy