Deleting records
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
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.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'