Page 1 of 1
Fail job while using Join stage
Posted: Tue May 24, 2016 3:54 am
by 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.
Re: Fail job while using Join stage
Posted: Thu May 26, 2016 1:49 am
by wuruima
I think the "abort after rows" in transfomer could help. you may try.
Posted: Thu May 26, 2016 1:50 pm
by 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.
Re: Fail job while using Join stage
Posted: Sun May 29, 2016 7:27 pm
by SURA
mobans wrote:How to fail job if there is no match on the key using Join stage?
Only if 100% no match ? or ...
Posted: Tue May 31, 2016 7:02 am
by 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.