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.