Reject file for Oracle connector in write method
Posted: Thu Feb 26, 2015 11:59 am
Hi,
I want to load some data into a Oracle table using oracle connector (in append mode). My job fails if there's some issue with the data load (like primary key violation, NULL value for not-NULL fields etc).
I want the job to continue and insert whatever it can and reject records which can't be inserted to a reject file.
Is this feasible in Datastage.
P.S. I found one logging property in Oracle connector. But that says 'Log column values on first row error'. Does this mean only the first row which encountered insert error will be logged, other rows can't be logged. If 10 out of 100 rows are rejected, will only 1st row be logged, not other 9 rows?
I want to load some data into a Oracle table using oracle connector (in append mode). My job fails if there's some issue with the data load (like primary key violation, NULL value for not-NULL fields etc).
I want the job to continue and insert whatever it can and reject records which can't be inserted to a reject file.
Is this feasible in Datastage.
P.S. I found one logging property in Oracle connector. But that says 'Log column values on first row error'. Does this mean only the first row which encountered insert error will be logged, other rows can't be logged. If 10 out of 100 rows are rejected, will only 1st row be logged, not other 9 rows?