Look-up
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 12
- Joined: Mon Sep 08, 2008 12:40 am
- Location: Hyderabad
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Look-up
Apply this logic in constraints tab
Condition Not Met : Fail
Lookup Failure : Continue
then you will get the Leftouter join results .
thx
Rama
Condition Not Met : Fail
Lookup Failure : Continue
then you will get the Leftouter join results .
thx
Rama
-
- Participant
- Posts: 12
- Joined: Mon Sep 08, 2008 12:40 am
- Location: Hyderabad
Re: Look-up
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
Shirishareddy
Re: Look-up
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 likeshirishareddy 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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Look-up
You are wrong.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
This is because the Condition Not Met rule is irrelevant to the original question.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.