Page 1 of 1
Hash File (Inner Join)
Posted: Mon Jun 23, 2008 6:28 am
by karry450
Hi Friends,
I am using a hashfile as a lookup in my server job, as a default it will be outer join . Is there any chance that I can make this as Inner Join.
If yes can anyone help me please.
Thanks
Re: Hash File (Inner Join)
Posted: Mon Jun 23, 2008 6:38 am
by sachin1
in constraint put "equal to" condition...........i mean
WHERE table_1.column_name = table_2.column_name...........taking database concept into consideration...........
Posted: Mon Jun 23, 2008 6:48 am
by chulett
Just check to see if the lookup succeeded and constrain the job to only pass rows where that is true. Use the Link Variable NOTFOUND, and Not() it to check for 'found'.
Inner Join.
Posted: Mon Jun 23, 2008 7:21 am
by karry450
chulett wrote:Just check to see if the lookup succeeded and constrain the job to only pass rows where that is true. Use the Link Variable NOTFOUND, and Not() it to check for 'found'. ...
Sorry Chulett,
I didnt understand ur concept.
Could you please enlarge in detail.
thanks
karthik
Posted: Mon Jun 23, 2008 7:28 am
by chulett
Not much to enlarge. You make the lookup an 'inner join' by only taking the rows where the lookup succeeded and using the 'Link Variables / Input' NOTFOUND value for that reference link to check.
Re: Inner Join.
Posted: Mon Jun 23, 2008 9:24 am
by vivekgadwal
karry450 wrote:chulett wrote:Just check to see if the lookup succeeded and constrain the job to only pass rows where that is true. Use the Link Variable NOTFOUND, and Not() it to check for 'found'. ...
Sorry Chulett,
I didnt understand ur concept.
chulett is asking you to do,
Code: Select all
NOT(<linkname from Hashfile>.NOTFOUND)
This
<linkname from Hashfile>.NOTFOUND is called a link variable and it is found the way chulett told in his post!
Thanks.