Lookup problem

hemaarvind1 · Post by **hemaarvind1** » Mon Mar 07, 2011 6:36 am

I am facing the below scenario.

I am having a source table ABC having columns col1,col2 and col3. I am having a lookup table 'ABC_Lookup' having columns col1 ,col2,col1_key and col2_key.

I am performing a lookup for ABC table on 'ABC_Lookup' table on the columns col1 and col2 to retreive the col1_key and col2_key respectively.

Suppose if I have nulls coming in col1 in ABC table and if a lookup is performed on col in 'ABC_Lookup' table, the output is 0 as col1 is defined as number.

however, in this case, the value for col2_key is also loaded as 0.it should ideally be populated with col2_key as the lookup is being performed on col2 in source and lookup tables.

can you please explain why is this happening and the solution for this.

Thank you very much.

nayanpatra · Post by **nayanpatra** » Mon Mar 07, 2011 7:38 am

When you are performing a lookup on 2 columns in the same stage, then the output is true only when both the conditions are met i.e. basically AND logic is being implemented. Only when you find a match for both the columns, the result is a valid one.

hemaarvind1 · Post by **hemaarvind1** » Mon Mar 07, 2011 7:40 am

Thank you very much for your quick reply. This resolved my issue..

chulett · Post by **chulett** » Mon Mar 07, 2011 7:41 am

Look them up separately.

hemaarvind1 · Post by **hemaarvind1** » Mon Mar 07, 2011 7:41 am

Thank you very much for your quick reply. This resolved my issue..