Hi All,
I am using stage constraint and abort rows as 1. When I run the job it stops immd when it violates the constraint but also it commits all the records till it processed. I don't want that to happen. Any chance of getting rollback in this if one record violates the constraint.
I am using oracle database. and the Rows per transactions is set to 0.
Kamal
Oracle Commit...
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: