Lookup comparisions
Posted: Mon Dec 19, 2011 2:43 pm
Hi,
I have one issue.
My source is a flat file. My lookup is Db2 database.
i have Source column which is Char datatype with 9 chars.
But my lookup up table column is Varchar data type with 15 in length.
My question is how can i trim the spaces and lookup based on the condition.
As far as in server jobs you can write Trim function in while joing the columns, But in Parallel job how should i do get perfect match values.
Please can you share you ideas ASAP
I have one issue.
My source is a flat file. My lookup is Db2 database.
i have Source column which is Char datatype with 9 chars.
But my lookup up table column is Varchar data type with 15 in length.
My question is how can i trim the spaces and lookup based on the condition.
As far as in server jobs you can write Trim function in while joing the columns, But in Parallel job how should i do get perfect match values.
Please can you share you ideas ASAP