I have a follwing job design
Code: Select all
OraTable -------->Transformer-------->OraTable
b> There are 2 targets, one for good records and other reject table where we will have bad records.
In the reject table , I want to capture the oracle error code for the rejected records.
I found that Enterprise Stage has default sqlcode column which gives error codes only for upsert failure and duplicate records.
I want to capture all the types of Ora errors.
Please provide your inputs on the same.
Gokul