Do you have any suggestions on how to handle nullable columns when the sequential file is a reject link? In that case, you don't have the option to handle nulls when you edit the row for the column. We have a large number of jobs with this situation, and a large number of columns in most of the related transformers, so options like putting a transformer or modify between the rejecting stage and the reject SF would be a pretty huge effort.
We had a suggestion to change the link from a reject to an 'otherwise', but we do have some situations where we generate output rows for every input row (I'm coding on one right now), so it seem that wouldn't work; and the situation is really errors that should cause the row to reject, like an error in a derivation on one of the output links.
Thanks for any ideas.
How to handle nullable columns in a reject link
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 12
- Joined: Wed Nov 04, 2009 1:24 pm
I believe , when you add reject link to sequential stage, you cann't handle null as it takes entire record as a single field "Rejected" (var binary notnull) you dont need to handle null here.
let me know if that is not a case
let me know if that is not a case
Regards,
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
-
- Participant
- Posts: 12
- Joined: Wed Nov 04, 2009 1:24 pm
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
-
- Participant
- Posts: 12
- Joined: Wed Nov 04, 2009 1:24 pm
-
- Participant
- Posts: 12
- Joined: Wed Nov 04, 2009 1:24 pm