DSXchange

Hi,

I am comparing 2 files which apparently have the same data. But when I mention a specific column SHIP_TO as a "value" the rows come up as "edited". When I mention the same SHIP_TO as a "Key" the rows show as "COPIES" not "inserts".

If the data in that field does not match it should show as "Inserts" right ?

Why does thi happen , Please Help ...

Can anyone explain me the difference between a "key" and a "Value" in a Change Capture stage ? ( apart from getting the result change code as "insert", "Delete" or "Edit" )

Even the manual can explain the difference between a Key Value column and a Change Value column.
The Key Value column must match before any other comparison will occur.
Change Value columns are the ones that are compared.

Hmm... Thanks Ray ....

That makes more sense to me ...