Reference lookup generated %d rows.

singhald · Post by **singhald** » Thu Nov 03, 2005 4:34 am

Hi

Wht is the meaning of this warning message.
"Reference lookup generated %d rows. Only the last row was used"
I got this warning message on Transformer where i m using a lookup (informix stgae).

so can u plz give me sol or exactly meaning of this warning message.

Singhal

ArndW · Post by **ArndW** » Thu Nov 03, 2005 4:40 am

singhald,

the message means exactly what it reported; you are doing a reference lookup but the key(s) that you used didn't return just one row but several. Since datastage uses only one value it had a to choose just one of those returned rows - in this case the last returned one.

You need to change your lookup criteria so that only a single row is returned.

chulett · Post by **chulett** » Thu Nov 03, 2005 7:52 am

The only confusing part might be the missing 'number of rows' that were actually returned. All you are seeing is the place-holder %d for a decimal number that is not being populated and is a bug in the stage, I would think.

In the long run it doesn't really matter, however - Arnd nailed the gist of it.

singhald · Post by **singhald** » Thu Nov 03, 2005 11:55 am

Hello Friends

I solved this problem. I added FIRST 1 in the select statement of sql ,
then the SQl statement return only one row at a time .
Thnks for your co-operation.

Deepak Singhal