how to get rejects in oracle stage

Edwink · Post by **Edwink** » Fri May 04, 2007 2:09 pm

Friends,
i m loading records into oracle through oci stage..
few records got rejected due to some constraints..
whether there is any way to collect the reject in a file?
transformer is the stage, before oci stage...
thanks

ds_developer · Post by **ds_developer** » Fri May 04, 2007 2:28 pm

Add a sequential stage and then a link from the Oracle stage to the sequential stage. In the Oracle stage, on the Properties tab, go to Options and set Output Reject Records = True.

John

Edwink · Post by **Edwink** » Fri May 04, 2007 2:46 pm

in Oracle stage i cant find the options?

DSguru2B · Post by **DSguru2B** » Fri May 04, 2007 2:53 pm

Reject mode will only work if its Upsert and will not work for Load. That too in the enterprise stage. Not the OCI stage.