Hey,
I am using LOAD option in oracle enterprise stage. When i load onto 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 column "Code" of datatype Varchar (5). when i load the data, its getting loaded as 'SM '
is there any env variable to solve this issuse or any workaround?
Oracle Load Characteristic
Moderators: chulett, rschirm, roy
Oracle Load Characteristic
Last edited by gsym on Mon Feb 23, 2009 8:19 pm, edited 1 time in total.
Re: Oracle Load Characteristic
Do you mean Datastage turned 'SM' to 'SA ' ?gsym wrote:Hey,
I am using LOAD option in oracle enterprise stage. When i load onto 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 column "Code" of datatype Varchar (5). when i load the data, its getting loaded as 'SA '
is there any env variable to solve this issuse or any workaround?
that is more seriously.
OOPS, sorry....Changed it now
That was a typo.