Hi,
In my previous job there was a lookup(fail-fail). But now I need to change it to JOIN as it cannot handle a very large volumn of data. But I am not able to fail the job when the conditions are not met,in the JOIN. So I am thinking of failing the job in a TRANSFORMER after the JOIN.
Plz let me know if it is possible to fail a job in the transformer.
Regards
Arnie.
Fail a job in transformer
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes, by detecting the failure condition, sending a row to a separate output link and, in the constraints grid, setting that link to fail the job when its row count reaches 1.
I advocate always creating jobs that do not abort, as that way you can maintain control more completely. In that case a different design, probably needing more than one job, would be needed to fulfil your requirements.
I advocate always creating jobs that do not abort, as that way you can maintain control more completely. In that case a different design, probably needing more than one job, would be needed to fulfil your requirements.
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.