Change capture not taking input from "before" link

[ady]

Sorry.... I confused u Kumar,

As you said, when there are new rows in the AFTER data it shows them as insert. But if the values in the existing rows are changed, how can I get those rows out ?


ex:

If this is the BEFORE data

111 aaa bbb

222 aaa bbb

333 yyy zzz



And this is the AFTER data


111 aaa bbb

222 aaa bbb

333 yyy xxx




I should get the output as :

333 yyy xxx


Can I get this with Change Capture or do I have to use a different stage?

[us1aslam1us]

Yes that record will be treated as an 'INSERT'

Sam

[ady]

I am giving the columns which I changed as "value columns". Its works now ... and it takes the changes I made as EDIT.