Look-up

shirishareddy · Post by **shirishareddy** » Wed Oct 14, 2009 6:24 am

How can i achive the Left outer join by using the Look-up stage?

ray.wurlod · Post by **ray.wurlod** » Wed Oct 14, 2009 6:32 am

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.

algfr · Post by **algfr** » Wed Oct 14, 2009 7:59 am

Couldn't have answered better

algfr · Post by **algfr** » Wed Oct 14, 2009 8:00 am

Couldn't have answered better

reddysrc · Post by **reddysrc** » Wed Oct 14, 2009 12:47 pm

Apply this logic in constraints tab

Condition Not Met : Fail
Lookup Failure : Continue

then you will get the Leftouter join results .

thx
Rama

shirishareddy · Post by **shirishareddy** » Thu Oct 15, 2009 3:00 am

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

Kryt0n · Post by **Kryt0n** » Thu Oct 15, 2009 2:01 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Oct 15, 2009 3:35 pm

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.

DSXchange

Look-up

Look-up

Re: Look-up

Re: Look-up

Re: Look-up

Re: Look-up