Fail job while using Join stage

[mobans]

How to fail job if there is no match on the key using Join stage?

Note: Due to high volume of data I can't use Lookup stage.

[wuruima]

I think the "abort after rows" in transfomer could help. you may try.

[Teej]

Use a generic stage, and use the abort operator.

Define $APT_ORCHHOME, $APT_CONFIG_FILE, source DSEngine\dsenv, and include $APT_ORCHHOME/bin in your PATH, and do the following command:

osh -fullusage abort

-T.J.

[SURA]

How to fail job if there is no match on the key using Join stage?

Only if 100% no match ? or ...

[ArndW]

I'd add a transform after the join stage and check for a null lookup column value there. If all columns joined are nullable then you have to add a new, dummy column in the lookup data which doesn't contain nulls.