how to create a lookup link in datastage

phanipriya · Post by **phanipriya** » Fri Mar 05, 2010 5:45 am

I have two tables customer & contact .customer is the primary table & contact is the secondary table.I am joining the tables and passing the output file .

While doing the link process between the databases and sequential file .
it throws me an error 40813 .The destination stage cannot support any more stream input links. As i have already have a stream link between contact table and sequential file.

So How do i create a lookup link between contact table and sequential file.

I don't see any options for creating an lookup link .
So can anybody suggest me how to create a lookup link .

Thanks

Sreenivasulu · Post by **Sreenivasulu** » Fri Mar 05, 2010 6:53 am

I think you need datastage training.

Regards
Sreeni

ArndW · Post by **ArndW** » Fri Mar 05, 2010 7:33 am

Parallel jobs work differently from Server jobs. In server the lookup is done through a transform stage, while in Parallel you have to use a lookup stage.

phanipriya · Post by **phanipriya** » Fri Mar 05, 2010 8:14 am

Hi Arnd ,

Thanks for the reply .

I am following this url for my job :-

http://www.ibm.com/developerworks/data/ ... g/#step1.1

In this tutorial If you look at fig:10 Job Diagram

There are two links

DSLINK3 is a stream link for the transformer
DSLink4 is a lookup link for the transformer

when i try to create DSLink4 i am getting it as a stream link and it
it throws me an error 40813 .The destination stage cannot support any more stream input links.

i don't find any options to create a lookup link .

This might be a funny issue for you all .But I am unable to solve it .
is this my server problem or do i need to change anything .

ArndW · Post by **ArndW** » Fri Mar 05, 2010 8:27 am

As I mentioned before, Server jobs perform lookups through transform stages and parallel jobs perform lookups through lookup stages. The example is a server job and you are working with a parallel job in the designer.

chulett · Post by **chulett** » Fri Mar 05, 2010 8:59 am

You've marked your job type as Parallel hence all the grief about how lookups work. If you are actually working with a Server job (as you need to be for this example) then you should be ok. Since I assume you've already created DSLink3 at this point as a solid lined stream link, when you create the second link, DSLink4, it should automatically create it as a dotted line reference lookup link.

If that's not working, give us some gory details. When you go to create DSLink4, what other links have already been created? DSLink3 only? DSLink3 and DSLink6? What 'direction' are you attempting to perform the lookup link, from where to where? Make sure you try going from CUST to JOIN_CUST_CNT if you're not doing that now.

I don't have access to a client any more so can't create the job and play along but we should be able to straighten this out with the details noted above.

phanipriya · Post by **phanipriya** » Fri Mar 05, 2010 9:12 am

Thanks chulett & ArndW

I have tried it as server job .it works.

.