change capture

[dnat]

Hi,

I have Col A,col B and col C in input file. also Col A,ColD in Ref table.

I am doing change capture between the file and the table and i want Col A,Col B,Col C and Col D in the output file. But in the output i am getting only ColD for taking as ouput. How can i get all the columns from input and output to the output file. Also, can i specify for each column which link value to take?

[ray.wurlod]

Use a Difference stage, or name the non-key columns differently. You don't need both copies of the key column, as it's identical.