Oracle Enterprise Stage Reject Handling not working properly
Posted: Wed Dec 08, 2010 2:57 am
Hi,
I am using a reject link attached to Oracle Enterprise stage . But facing following issues :
1. It is rejecting records only for ORA-1400 (Inserting null into not null value )
2.If source data has column value more than specified in database i.e ORA-Value too long for column ,job is getting aborted instead of rejecting that record to reject link .
3. As Reject link meatdata is non editable ,i am unable to handle null values for timestamp and decimal fields ,Its giving 1 warning for each field in reject metadata .I tried using modify stage also , but facing issue with decimal and data null handling .
Does Oracle Enterprise Stage reject records for only -1400 and not for other oracle errors ,please suggest how to handle null values for non editable metadata of reject file.
I am using a reject link attached to Oracle Enterprise stage . But facing following issues :
1. It is rejecting records only for ORA-1400 (Inserting null into not null value )
2.If source data has column value more than specified in database i.e ORA-Value too long for column ,job is getting aborted instead of rejecting that record to reject link .
3. As Reject link meatdata is non editable ,i am unable to handle null values for timestamp and decimal fields ,Its giving 1 warning for each field in reject metadata .I tried using modify stage also , but facing issue with decimal and data null handling .
Does Oracle Enterprise Stage reject records for only -1400 and not for other oracle errors ,please suggest how to handle null values for non editable metadata of reject file.