DSXchange

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.

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.