Hi friends,
My source is oracle and also target but I am using oracle bulk load stage.
But I am not getting an unique constraint error when loading the same data in target for the second time.
I have checked and my target is defined with primary keys.
Can anyone help is it possible to handle/reject duplicate records using oracle bulk load stage in server jobs.
Thanks
Karthik
Unique Constraints.
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Prevention is always better than cure.
If you can't manage that, then the duplicates should be discarded into the sqlldr "bad" file and mentioned in the "log" file.
If you can't manage that, then the duplicates should be discarded into the sqlldr "bad" file and mentioned in the "log" file.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.