Data Loaded in target table with Some Spaces

praburaj · Post by **praburaj** » Wed Mar 11, 2009 12:46 am

Hi,

My source is DB2. When I load the data into the Char field (6) in to target table, the data is getting loaded with spaces. I have tried with trim option also. But it does not work.
EX:

This is my job flow

DB2---->Transformer-->DB2;

Source Target

RMTYPE_ C RMTYPE_C

MUL MUL 
SEQ SEQ

Please help me to resolve this issue.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 11, 2009 2:22 am

Use VarChar instead of Char as the data type. Of course, if the data type in the actual table is Char then the column has to be padded with something.