zero not to be truncated

[adityavarma]

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

[ArndW]

Your target is an integer column and thus, by definition, does not have leading zeros. If you want leading zeroes on displaying an integer column you will need to declare to the output format accordingly.

[rohithmuthyala]

Keep the target column as Varchar.May i know what is your final target is it a sequential file...?
If so one can directly populate target column into the sequential file as varchar.

[adityavarma]

The target is oracle table and the datatype is integer, so in the target i want the value to be 03

[Sainath.Srinivasan]

'03' is only a displaytype for integers. You can do something like

Code: Select all

SELECT to_char(yourIntField, '00')
FROM yourTable 

[chulett]

The target is oracle table and the datatype is integer, so in the target i want the value to be 03

Sorry, but it doesn't really matter that is what you 'want', leading zeroes are not stored in any kind of numeric field. As noted, however, you can make it look the way you want when you extract it with the proper TO_CHAR() conversion and format mask.

[ray.wurlod]

In Oracle an integer with a value of 3 will be stored as (binary) 00000000000000000000000000000011