November 28th, 2013, 04:30 AM
How to convert string into number using expression transformation in informatica?
November 28th, 2013, 04:35 AM
i have source column(amount) with datatype string, contains the datas like $793.00, $5791.00,...
I need to load this same data into the target table column(amount) with datatype NUMBER
how can i get this same data with '$' symbol in target by using expression transformation in informatica?
anyone help me please, thanks in advance.
or if it's always the first character and you don't have to worry about spaces