how to reject records from target Oracle connector stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
prasson_ibm
Premium Member
Premium Member
Posts: 536
Joined: Thu Oct 11, 2007 1:48 am
Location: Bangalore

how to reject records from target Oracle connector stage

Post by prasson_ibm »

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.
vinothkumar
Participant
Posts: 342
Joined: Tue Nov 04, 2008 10:38 am
Location: Chennai, India

Re: how to reject records from target oracle copnnector stag

Post by vinothkumar »

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.
Post Reply