Hash File (Inner Join)

karry450 · Post by **karry450** » Mon Jun 23, 2008 6:28 am

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

sachin1 · Post by **sachin1** » Mon Jun 23, 2008 6:38 am

in constraint put "equal to" condition...........i mean
WHERE table_1.column_name = table_2.column_name...........taking database concept into consideration...........

chulett · Post by **chulett** » Mon Jun 23, 2008 6:48 am

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'.

karry450 · Post by **karry450** » Mon Jun 23, 2008 7:21 am

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

chulett · Post by **chulett** » Mon Jun 23, 2008 7:28 am

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.

vivekgadwal · Post by **vivekgadwal** » Mon Jun 23, 2008 9:24 am

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.

DSXchange

Hash File (Inner Join)

Hash File (Inner Join)

Re: Hash File (Inner Join)

Inner Join.

Re: Inner Join.