Oracle Load Issuse, Data loaded with trailing spaces
Posted: Tue Mar 10, 2009 9:50 am
Hey,
I am using LOAD option in oracle enterprise stage. When i load data into the VARCHAR Field, the data is getting loaded with spaces.
Example
Assume the job as follows
Oracle -----> Transformer------->Oracle
In transformer i am defaulting a value 'SM' for a column of datatype Varchar (5). when i load the data, its getting loaded as 'SM ' (with trailing spaces). I tried trimming the data via datastage but it dosent work.
is there any env variable to solve this issuse or any workaround? or is it a default characteristic of LOAD?
I am using LOAD option in oracle enterprise stage. When i load data into the VARCHAR Field, the data is getting loaded with spaces.
Example
Assume the job as follows
Oracle -----> Transformer------->Oracle
In transformer i am defaulting a value 'SM' for a column of datatype Varchar (5). when i load the data, its getting loaded as 'SM ' (with trailing spaces). I tried trimming the data via datastage but it dosent work.
is there any env variable to solve this issuse or any workaround? or is it a default characteristic of LOAD?