zero not to be truncated
Posted: Tue Oct 05, 2010 2:10 am
Hi,
I have a source file which is fixed width and i am using substring function to fecth the value i.e testcolumn[25,2] and the value in source column (varchar) is '03' and the target is integer(2) field.
In between, the source and target i am using a transfomer stage for transfomations on other columns,but the testcolumn is an direct load
when i load the data to the target dataset, the value been loaded is 3, instead the target should be 03.
The zeros are been truncated before i laod to the target, which should not be the case here.
Can anyone please help me on this.
Regards,
Aditya
I have a source file which is fixed width and i am using substring function to fecth the value i.e testcolumn[25,2] and the value in source column (varchar) is '03' and the target is integer(2) field.
In between, the source and target i am using a transfomer stage for transfomations on other columns,but the testcolumn is an direct load
when i load the data to the target dataset, the value been loaded is 3, instead the target should be 03.
The zeros are been truncated before i laod to the target, which should not be the case here.
Can anyone please help me on this.
Regards,
Aditya