Lookup Issue

senthilt1 · Post by **senthilt1** » Wed Jul 06, 2011 6:38 am

Hi Team,

I am doing simple lookup b/w source and reference using Lookupstage.

My source has column as
col1 varchar(255) -> value = Product group category
My reference has column as
abc varchar(20) -> value = Product group cate

I am doing a lookup between this two columns and taking some column out from reference, To my understanding it should not match for the value i have provided. But its matching and gives the output correctly. But it throws the warning of possible truncation.

This is how, the lookup functions? so it would match the values upto varchar(20) from source varchar(200)???

Please let me know.
Thanks,

jwiles · Post by **jwiles** » Wed Jul 06, 2011 9:30 am

The lookup will not truncate for matching purposes. If the two columns are exactly the same (length and contents) they will match, otherwise they will not match.

The truncation warning message may be coming because of the length of your output columns. Do your output columns have the same defined length as they do at input? For instance, if you have col1 defined as a varchar(20) on the output link and it's varchar(200) on input, you will get the warning.

Regards,