Need help in Change Capture stage

[peddakkagari]

I have requirement like below

Before File:

Key Non_Key
1 a
2 b
3 c

After File:

Key Non_Key
1 a
2 d
4 e

Then how many records i will get after ChangeCapture stage and what is the value of the "ChangeCode()" field ?

[netgurutoo]

You can easily get the answer you want by looking at the developers guide

You should get 4 rows

Key Non_Key Change code
1 a 0 (Copy)
2 d 3 (Edit)
3 c 2 (Delete)
4 e 1 (Insert)

You can make the change codes whatever you want. Above are defaults.

[peddakkagari]

Thanks a lot, your reply really helped me