top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

Formatting a column using Expression Transformation in Informatica Powercenter

+1 vote
133 views

I have a Column (SALARY) in Source Table from Relational DB, for example 15000 is a record in SALARY column and I want to format it as $15,000.00 into the Target table which is a Relational DB using Expression Transformation.

Thankyou

posted Oct 15, 2014 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Hi...

Change the datatype to decimal scale 2 in the target db SALARY column.

answer Oct 16, 2014 by anonymous
Similar Questions
+2 votes

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?

+1 vote

I have an xml file my tag is like

<'mytag'>'data'<'/mytag'>

I need to find position of <'/mytag'> using Informatica Expression transformation. How can I achieve that?

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...