I absolutely assure that I pick up the right fields as the keys, and I check the "key" option of these fields in the columns list.exclude values: some fields I don't want to compare
change keys: fields as keys
options:
change mode=Explicit Keys, All Values
other settings as default.
But when I run the job, I get the error:
Change_Capture: A field cannot be both a key and a value.
If I set
, and explicit the key fields and values fields, it works out.change mode= Explicit Keys & Values
How could that happen? I've spent nearly all day on that problem. Please help!