Page 1 of 1
Look-up
Posted: Wed Oct 14, 2009 6:24 am
by shirishareddy
How can i achive the Left outer join by using the Look-up stage?
Posted: Wed Oct 14, 2009 6:32 am
by ray.wurlod
Set the Lookup Failed rule to "Continue" and make sure that columns on the reference input and columns on the output that are derived from these are all marked as Nullable.
Posted: Wed Oct 14, 2009 7:59 am
by algfr
Couldn't have answered better
Posted: Wed Oct 14, 2009 8:00 am
by algfr
Couldn't have answered better
Re: Look-up
Posted: Wed Oct 14, 2009 12:47 pm
by reddysrc
Apply this logic in constraints tab
Condition Not Met : Fail
Lookup Failure : Continue
then you will get the Leftouter join results .
thx
Rama
Re: Look-up
Posted: Thu Oct 15, 2009 3:00 am
by shirishareddy
reddysrc wrote:Apply this logic in constraints tab
Condition Not Met : Fail
Lookup Failure : Continue
then you will get the Leftouter join results .
thx
Rama
If we set the Condition Not Met=FAIL, job will fail.I guess we need to give the Condition Not Met=DROP.Correct me if i am wrong
Re: Look-up
Posted: Thu Oct 15, 2009 2:01 pm
by Kryt0n
shirishareddy wrote:
If we set the Condition Not Met=FAIL, job will fail.I guess we need to give the Condition Not Met=DROP.Correct me if i am wrong
Condition not met is only relevant if you apply a condition (i.e. a condition to determine if the lookup should be done). If you aren't applying a condition, set this to whatever you like
Re: Look-up
Posted: Thu Oct 15, 2009 3:35 pm
by ray.wurlod
shirishareddy wrote:If we set the Condition Not Met=FAIL, job will fail.I guess we need to give the Condition Not Met=DROP.Correct me if i am wrong
You are wrong.
This is because the Condition Not Met rule is irrelevant to the original question.