Capturing rejected rows in Oracle
Moderators: chulett, rschirm, roy
Capturing rejected rows in Oracle
Hi,
I am trying to insert data in a Oracle db using Oracle OCI stage.
I need to capture the records which failed to insert in the table.
So I have created a new link and marked the link as rejected and in transformer i have put a constraint like oracletable_linkname.REJECTED on the rejected link.
but the rejected data is not coming into the link though the job is throwing a warning message.
But the same approach is working fine when i use for Sybase or Sql db.
I have searched before posting this.
Can anyone please help me on this
Thanks in advance.
I am trying to insert data in a Oracle db using Oracle OCI stage.
I need to capture the records which failed to insert in the table.
So I have created a new link and marked the link as rejected and in transformer i have put a constraint like oracletable_linkname.REJECTED on the rejected link.
but the rejected data is not coming into the link though the job is throwing a warning message.
But the same approach is working fine when i use for Sybase or Sql db.
I have searched before posting this.
Can anyone please help me on this
Thanks in advance.
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
If the record is getting rejected due to null values and if you are redirecting this to a sequential file then it will not load to this file. This happens as a sequential file cannot be loaded with null values
You can use a MODIFY stage to change the null values to some default value. This will then enable the records to go to the sequential file
Regards
Sreeni
You can use a MODIFY stage to change the null values to some default value. This will then enable the records to go to the sequential file
Regards
Sreeni
OK, let's go the opposite direction then. Do not mark the link as a Reject link and restore your 'LinkName.REJECTED' constraint value. Make sure you pick that from the Helper rather than type it in manually.
Both of those approaches should work just fine. If they're not, we're missing something important. What Array Size value are you using in the target stage? It will need to be set to 1 if you want your Reject mechanism to work properly.
Both of those approaches should work just fine. If they're not, we're missing something important. What Array Size value are you using in the target stage? It will need to be set to 1 if you want your Reject mechanism to work properly.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 14
- Joined: Mon Jan 19, 2009 9:06 pm
-
- Participant
- Posts: 14
- Joined: Mon Jan 19, 2009 9:06 pm