DSXchange

I need only to delete matching columns

rafidwh wrote:I need only to delete matching columns

It will delete matched row as you can see in sql view ...

Why dont you try in test enviroment....

Thanks,
Anupam

Use the update action "replace existing rows completly". Define all the keys properly as it supplies that key as the where predicate for the delete. Read into that update action, or as Anupam mentioned, look at the sql.

I have no option to try now, but may I know what is the interesting SQL generated? Where my guess goes like, first datastage tries to insert the row and due to constraints it fails, and later tring to delete the row, and so deleting the left out table row.