Hi,
I have a job where source and targets are oracle connector.on target connector stage I have put a reject link and want to reject records which are violation primary key constraint or data type issues
But instead of rejecting these rejecord,job is aborting if unique key constraint violation occers.Can someone suggest that how I can hadle these records in reject output.
how to reject records from target Oracle connector stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
how to reject records from target Oracle connector stage
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
Re: how to reject records from target oracle copnnector stag
Under Reject link properties, there will be some property to mention number of reject rows based on which job will abort. Default will be 1. Set it to 0.