reject link order
Moderators: chulett, rschirm, roy
reject link order
Usually we have the reject link as the last link from the transformer to ensure that it captures rejects of the EARLIER output stages.. I have a job that has 2 output OraOCI stages and a sequential file stage (which has the rEJECT row ticked) My goal is to have the same data coming out of the transformer to be written to both the tables represented by the 2 OraOCI stages and the rejects to be written to the reject file.
It doesnt seem to matter if the have the reject link placed 2nd in order (between links 1 and 3 to the oracle stages) or if the reject link is placed last. Can anyone help me understand why ?
It doesnt seem to matter if the have the reject link placed 2nd in order (between links 1 and 3 to the oracle stages) or if the reject link is placed last. Can anyone help me understand why ?
thanks Kenneth.
But still my question stays unanswered. I have it as a rule of thumb and always design my jobs to have reject link as the last one out of the transformer.. but even if i put it in the second place.. still doesnt seem to matter and i started questioning my assumption and needed clarification of the same..
But still my question stays unanswered. I have it as a rule of thumb and always design my jobs to have reject link as the last one out of the transformer.. but even if i put it in the second place.. still doesnt seem to matter and i started questioning my assumption and needed clarification of the same..
The manual tells you to do it. It used to be required as the last link when DS 4 came out, but in prior releases it didn't matter. Maybe IBM will change their minds. In the meantime, follow the manual.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A [rejects] link processes any row that has not been output on any earlier-executed output link.
Read that statement carefully.
What it means is that the reject link will not capture any row that fails to be put onto any subsequently executed output link.
It also means that a second [rejects] link will never process any rows.
Read that statement carefully.
What it means is that the reject link will not capture any row that fails to be put onto any subsequently executed output link.
It also means that a second [rejects] link will never process any rows.
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.