Hi ,
I have a job in which Iam doing a lookup to a db2 table directly with out out using any hash files for a column Annd and when Iam doing that Iam getting an warning.
Preprocessor_CheckAnnouncement..Xfom_ANNDoc: Reference lookup generated 9555 rows. Only the last row was used.
I tried in select statement using Distinct Annd and with out distinct in select statement . But Iam getting the same warning .
Can some one tell me why Iam getting this warning
Thanks,
SomaRaju.
Warning when directly doing a lookup to Db2 table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Because you're doing a lookup on something that is not unique in the DB2 table - that is, neither the primary key nor a column that has a UNIQUE constraint.
DISTINCT does not help if there are other columns in the lookup query; these would have to all be identical to reduce the count.
The DB2 stage can not support multiple returns from a lookup. This is only supported by the ODBC stage and the UniVerse stage. You could use an ODBC stage if multi-row return is what you require (for example 9555 rows out of the Transformer stage for one row in).
DISTINCT does not help if there are other columns in the lookup query; these would have to all be identical to reduce the count.
The DB2 stage can not support multiple returns from a lookup. This is only supported by the ODBC stage and the UniVerse stage. You could use an ODBC stage if multi-row return is what you require (for example 9555 rows out of the Transformer stage for one row in).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.