"Keys" and "Values" in Change Capture

ady · Post by **ady** » Tue Apr 03, 2007 8:27 am

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 ...

ady · Post by **ady** » Tue Apr 03, 2007 9:56 am

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" )

ray.wurlod · Post by **ray.wurlod** » Tue Apr 03, 2007 10:44 pm

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.

ady · Post by **ady** » Wed Apr 04, 2007 1:40 pm

Hmm... Thanks Ray ....

That makes more sense to me ...