DSXchange

Posted: **Thu Feb 01, 2007 3:17 am**

Hi,

I am using table lookups using two keys. The lookup get failed
showing the below mentioned description.

LU failure found on link Lookup_Warehouse for InputKey 41168|2004

Thanks

Vinod

Posted: **Thu Feb 01, 2007 4:12 am**

Vinod - ok, the lookup fails and doesn't find a value. What is your question?

Posted: **Thu Feb 01, 2007 4:46 am**

Is it Server Edition?
There is no data available for the given data in the reference table.

Posted: **Thu Feb 01, 2007 4:26 pm**

Are you trying to assemble a composite key with a "|" between them? This is not the right way to perform a lookup against a data source that has two keys. You must provide separate values for the separate key columns.

Please advise whether this is a server job (as marked) or a parallel job (as posted).

DSXchange

Lookup failure

Lookup failure