Strange Lookup warning

Enzopre · Post by **Enzopre** » Tue Jun 18, 2013 4:59 am

Hi at all

I'm using a lookup stage in datastage 8.7, but i get a strange warning as the follow:

Lookup: When checking operator: Dropping component "CUSTOMER_NUMBER" because of a prior component with the same name.

Customer_Number is the lookup key and so it is present both reference link and primary link.

I had used the lookup stage also in datastage 8.1 in the same way but i did not got this warning.

Can anyone help me?

regards.

prasson_ibm · Post by **prasson_ibm** » Tue Jun 18, 2013 5:53 am

Hi,
Change the column name in one of the link and try again.

crystal_pup · Post by **crystal_pup** » Tue Jun 18, 2013 5:58 am

As per the 8.7 development guide - "The lookup key columns do not have to have the same names in the primary and the reference links".So using "CUSTOMER_NUMBER" as the key column name in both the links shouldn't throw any warning. As Prasoon suggested, for the time being use different column names and it should work.

Also, In case you are able to find out why the warning is being generated when the key column names are same, then let us know as well

prasson_ibm · Post by **prasson_ibm** » Tue Jun 18, 2013 6:05 am

Hi,
Even in the case you are getting the warning and names are not duplicate in both the input links,they are usually being propagated invisibly through the job because RunTime Column Propagation is turned on.

Enzopre · Post by **Enzopre** » Tue Jun 18, 2013 6:10 am

hi,

the problem is resolved. In the output page of lookup stage properties i have unchecked the "Runtime Column propagation" option and the warning is disappeared.

Now, the question is: Why?

ray.wurlod · Post by **ray.wurlod** » Tue Jun 18, 2013 6:35 am

Because CUSTOMER_NUMBER column was being propagated even though not named on the link.