Lookup Issue
Posted: 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,
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,