Equivalent Oracle TO_NUMBER function
Posted: Mon Mar 06, 2006 1:19 pm
Hi Guys,
Can you guys please clarify my doubt on Oracle to_number function equivalent in Datastage.
I have a inputfield varchar(10) and output oracle filed is Number.
In oracle we will give to_number(fieda).I know in Datastage we will move directly from varchar to numeric without any conversion.
Please clarify my doubt. on do we any conversion to move from character to numeric viceversa...
Thanks in advance
Reddy
Can you guys please clarify my doubt on Oracle to_number function equivalent in Datastage.
I have a inputfield varchar(10) and output oracle filed is Number.
In oracle we will give to_number(fieda).I know in Datastage we will move directly from varchar to numeric without any conversion.
Please clarify my doubt. on do we any conversion to move from character to numeric viceversa...
Thanks in advance
Reddy