Deleting records

rafidwh · Post by **rafidwh** » Fri Jun 16, 2006 6:14 am

I need only to delete matching columns

sb_akarmarkar · Post by **sb_akarmarkar** » Fri Jun 16, 2006 6:41 am

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

DSguru2B · Post by **DSguru2B** » Fri Jun 16, 2006 7:16 am

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.

kumar_s · Post by **kumar_s** » Fri Jun 16, 2006 9:49 am

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.