Hi, We are mapping data from sql to sql and taken a reject link from Transformer for reject data, but the thing is rejecting the data without any logic in transformer and it's converted into the reject link.
we have 4 keys. Those are Varchar only.
Please tell some one how it's happening, i never seen such thing
Rejecting data without any logic from transformer to seqfile
Moderators: chulett, rschirm, roy
Reject links from Transformers are either for Server jobs or for logical constraint driven rejects. In Parallel jobs they are typically directly from the target stage. If your "reject" link doesn't have a constraint on it, however, then every record you push through the job will go down it. Is that what you mean by "without any logic in the transformer"?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A reject link from a parallel Transformer stage handles any row that causes an exception.
Parallel Transformer stage also has an "Otherwise/Log" link that handles any row that has not been transferred to any previous output link. It is this link type that is the equivalent of the server/BASIC Transformer stage's "reject" output link.
No logic is required in either case. The logic for detecting that a row has not been transferred to any prior output link is built into the stage itself (you can view the generated source code if you wish to confirm this).
Parallel Transformer stage also has an "Otherwise/Log" link that handles any row that has not been transferred to any previous output link. It is this link type that is the equivalent of the server/BASIC Transformer stage's "reject" output link.
No logic is required in either case. The logic for detecting that a row has not been transferred to any prior output link is built into the stage itself (you can view the generated source code if you wish to confirm this).
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.
Figured if it worked like the Server version that it was a "catch all" and only took rows that didn't go down any other link. Automatically. Without any specific logic.
Just was a little confused about calling it a "reject" link when what I recalled wasn't really called that except in a Server job. I'm all caught up now, thanks.
Just was a little confused about calling it a "reject" link when what I recalled wasn't really called that except in a Server job. I'm all caught up now, thanks.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Almost.
In parallel jobs, database errors are not handled by the Transformer stage's reject link but, rather, by a reject link from the stage that connects to the data source/target.
It is true that is server jobs database errors are handled by the Transformer stage reject link.
In parallel jobs, database errors are not handled by the Transformer stage's reject link but, rather, by a reject link from the stage that connects to the data source/target.
It is true that is server jobs database errors are handled by the Transformer stage reject link.
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.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI