Lookup

auvray.muriel · Post by **auvray.muriel** » Thu May 06, 2004 1:13 pm

hello
I beginning on PX.
I am much more at ease on Datastage server.

I do not manage to have a lookup in reference.
As soon as I want to set up the bond, I have an error message which says that the training course to transform cannot receive several direct links in input.
somebody can it explain to me how to pass this bond in reference ?

Thanks

Code: Select all

                                           lookup
                                              |
                                              |
                                              |
                                              v
             DB2 table ------------------->Transfo -----------------> Sequential file

Eric · Post by **Eric** » Fri May 07, 2004 6:27 am

I think you have to ...

Code: Select all

    DB2
      |
 -Lookup---Trans---

auvray.muriel · Post by **auvray.muriel** » Fri May 07, 2004 8:14 am

What I want to do, it is for each recording of the table, I must recover a field in the lookup, by making a joint on the key field of the lookup (like a hasfile on a job server)

In a preceding job, I charge the lookup.

Thanks for your help

Muriel Auvray