DSXchange

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.

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.