Lookup failure

vinodhraj · Post by **vinodhraj** » 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

ArndW · Post by **ArndW** » Thu Feb 01, 2007 4:12 am

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

kumar_s · Post by **kumar_s** » Thu Feb 01, 2007 4:46 am

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

ray.wurlod · Post by **ray.wurlod** » 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).