Problem with “delete data from table before loading”

dataservices job design
1

When I check the option “delete data from table before loading” and execute the job I have no problem, but when I uncheck this option, I get the error “unique constraint….violated”.
My data flow is as:
Sources-> Query->TC->KG->Target.
Please advice where I am missing.
Thanks

Binary :australia: (BOB member since 2006-09-27)

2

How are you handling the records that has to be updated/deleted? I mean after the Table Comparison, you would have to use the Map Operation to handle those records.

ganeshxp :us: (BOB member since 2008-07-17)

3

Can you please suggest me the DF. Thanks

Binary :australia: (BOB member since 2006-09-27)

4

This might be of help Table comparison for delete rows is not working

@rocky (BOB member since 2010-09-26)