Lookup is not perform.

avi2kus · Post by **avi2kus** » Mon Jan 16, 2006 3:58 am

i am Ravi.

My problem is very simple. In my object Lookup is not happen. In my object they gave one condition. that is CABNT-ATBEZ=ZZCOLOR_ZZ-ATBEZ, here CABNT and ZZCOLOR are the source tables , Lookup is not happen.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 16, 2006 4:42 am

Welcome aboard. :D

The Lookup stage has specific requirements, in that you need to have set up the Key property for the lookup to occur (and, possibly, whether to perform the lookup at all).

Can you draw an ASCII picture of your job design so we have a clearer idea of what you are trying to achieve? For example

Code: Select all

                     Oracle  (CABNT)
                         |
                         V
    Oracle  ------->  Lookup  ----->  Peek
  (ZZCOLOR)

Can the join be performed in the database, so you don't need to do it in DataStage at all?

Please tell us also how you have set the properties in the Lookup stage.

vmcburney · Post by **vmcburney** » Mon Jan 16, 2006 8:58 pm

Do a view data on the source and lookup tables and copy and paste key fields to notepad, look for extra padding or funny characters as these can prevent lookups from working.