Records are wrongly rejected for Unique key

skaruturi · Post by **skaruturi** » Thu Feb 08, 2007 2:46 am

We are having a column(Say SampId) of data type varchar(50)
Suppose the records are given as
1234567890121212
1234567890121213

The second record is rejected in the job for unique key.

kumar_s · Post by **kumar_s** » Thu Feb 08, 2007 2:58 am

Varchar(50) is capable of holding the given data.
You may need to check the data is been truncated, particularly last digit during transformation.
You need to explain more of your job design and the method of load.

Krazykoolrohit · Post by **Krazykoolrohit** » Thu Feb 08, 2007 12:37 pm

Trim the fields of any spaces before you do the lookup. If one of the field is filled with spaces, you lookup will fail

DSguru2B · Post by **DSguru2B** » Thu Feb 08, 2007 1:35 pm

As Kumar requested, more information is required. For all we know, the id might already exist in the table.