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.
Fail job while using Join stage
Moderators: chulett, rschirm, roy
Re: Fail job while using Join stage
I think the "abort after rows" in transfomer could help. you may try.
wuruimao
Re: Fail job while using Join stage
Only if 100% no match ? or ...mobans wrote:How to fail job if there is no match on the key using Join stage?
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>