URGENT:map_cdc_operation, the deleted data could not updated

dataservices job design
1

I use the CDC mode extractor through a subscription, and pass through the map_cdc_operation and then the target. In the debug mode, I saw the rows flagged as I,U,D but the target table is getting only updates(no deletes). It looks like the target tables could not read the deleted records and updated accordingly. I already set PKs before the map_cdc_operation and the target table.

Help is appreciated! Urgent help needed! Thanks!
deleted record 2.JPG
deleted record.JPG

ICEFISH (BOB member since 2016-09-14)

2

Please provide the properties of your target: list of fields in the key + target options.

jd.pro :fr: (BOB member since 2010-11-15)