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 ...
"Keys" and "Values" in Change Capture
Moderators: chulett, rschirm, roy
"Keys" and "Values" in Change Capture
Last edited by ady on Tue Apr 03, 2007 12:17 pm, edited 2 times in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
The Key Value column must match before any other comparison will occur.
Change Value columns are the ones that are compared.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.