look up warning

samsuf2002 · Post by **samsuf2002** » Tue Feb 27, 2007 10:22 am

Hi All , I am running a paralle job in which i am doing a look up (lookup stage) from a table using ODBC stage (data base SQL server) for joining 4 columns on 2 keys .i am getting this warning

Lookup_392,0: Ignoring duplicate entry at table record 2; no further warnings will be issued for this table

Can anyone hekp me on this
Thanks in Advance

us1aslam1us · Post by **us1aslam1us** » Tue Feb 27, 2007 10:27 am

The warning tells you that the key value in the lookup data has duplicates. Either remove duplicate or handle the duplicate with the option avaialbe in Lookup.

samsuf2002 · Post by **samsuf2002** » Tue Feb 27, 2007 10:30 am

How we should handle the dups in look up stage?

ray.wurlod · Post by **ray.wurlod** » Tue Feb 27, 2007 3:44 pm

Remove Duplicates stage upstream. Or a sort (Sort stage or input link sort) with the "unique" option selected.

kumar_s · Post by **kumar_s** » Tue Feb 27, 2007 6:16 pm

samsuf2002 wrote:How we should handle the dups in look up stage?

In Lookup Stage Condition page, select the Link name where the lookup is entering in "Multiple rows returned from link" option.