Look_up warning

deesh · Post by **deesh** » Fri Apr 17, 2009 6:25 am

Hi Friends,
I am encountering the Lookup warning can tell to me the solvation This data coming from SQL Server

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

dsuser_cai · Post by **dsuser_cai** » Fri Apr 17, 2009 8:14 am

When even you import data from any files, please make sure you have the proper format, i mean delimiters, some times the data might have the delimiter in it and this may cause some issues. For example, we use pipe delimited files (|), normally the data that we get wont have this, when we create the staging files we delimit with a Pipe symbol, but actually one day the data had pipe symbols and we missed nearly 72 records. I believe that should be the case with you too.

chulett · Post by **chulett** » Fri Apr 17, 2009 8:18 am

In other words, how you've defined the file contents in the stage (your metadata) doesn't match reality, what's actually in the file. You need to correct that.

mikegohl · Post by **mikegohl** » Fri Apr 17, 2009 9:29 am

What is the SQL Server Key and what key did you choose for the lookup?

girija · Post by **girija** » Fri Apr 17, 2009 9:41 am

This warning means you have duplicate keys in the lookup data. Just run the same query with goup by the keys and cout, you found some keys with more than one count.

chulett · Post by **chulett** » Fri Apr 17, 2009 9:50 am

Dude, that is totally uncool. You edited your original post to not only change the subject but to also to replace the original question with a completely different one, such that our first two replies now make zero sense.

Nex time, just move on and start a new post.