Page 1 of 1

Capturing rejects in Oracle OCI stage

Posted: Tue Sep 25, 2012 9:26 am
by Maximus_Jack
I'm inserting records into oracle oci stage, whenever the insert fails for whatever reason
i need to capture that in a sequential fail of the rejected records, i tried adding a sequential
file at the end of the oracle oci stage but i couldnt find any reject options, can anyone help me?

thanks

Posted: Tue Sep 25, 2012 10:01 am
by chulett
In a Server job the reject link goes on the transformer feeding the target, not the target itself.

Posted: Tue Sep 25, 2012 5:29 pm
by chulett
FYI - In essence they reject "back up" the link and can then be captured in a later link that is marked as a Reject link or has a constraint that checks the REJECTED link variable.