Hi,
My target data base is oracle , i use OCI stage to load records , when i load the data its throwing warnings like ORA-01722: invalid number. i dont want to load these records into target , i want to load in reject file . when i give the constraint to reject link its loading the rejected records into file and throwing the same warning,
Any suggestions to over come this issue.
thanks in advance
Capture reject records
Moderators: chulett, rschirm, roy
Capture reject records
D.N .MURTHY
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
You can use the oracle connector within a parallel container in your server job
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why didn't you post the question in the Server job forum?
In server jobs the reject link from a Transformer stage that feeds the OCI stage is used to capure rejected rows. Link variables can be used to capture the DBMS error code and message.
In server jobs the reject link from a Transformer stage that feeds the OCI stage is used to capure rejected rows. Link variables can be used to capture the DBMS error code and message.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Capture reject records
Well, here we are in Server Town now.
That's how it works, the warning is always logged.dr.murthy wrote:when i give the constraint to reject link its loading the rejected records into file and throwing the same warning
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers