[i]Did you set 'Drop output for Delete' = false in the stage?[/i]
yes, i did. all the fields on the "deletes" dataset have values in them except for the key that is set as "excluded as value". this is bizzare.
thanks for replying.
Search found 2 matches
- Tue Oct 23, 2007 2:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CDC Stage - issue capturing deletes
- Replies: 3
- Views: 893
- Tue Oct 23, 2007 1:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CDC Stage - issue capturing deletes
- Replies: 3
- Views: 893
CDC Stage - issue capturing deletes
hello there. i am running a job that compares latest extract with the before extract and captures new, updated and deleted records in a dataset each. change mode is set to "explicit keys, all values". everything works beautifully except for the fact that "excluded as value" column on the dataset tha...