Skip navigation
Contact Us
2063 Views 2 Replies Latest reply: Dec 24, 2012 10:13 AM by RSS Novice 25 posts since
Oct 8, 2012
Currently Being Moderated

Dec 21, 2012 1:31 PM

Reg: number(p,s) conversion in Informatica!

Can anyone help me with teh following scenario?


I  have a source which has a column with datatype number(p,s).

When I drag the table to build a mapping, the datatype of the source qualifier is converted to Decimal.

But the values are not being populated correctly in the Traget.



Source           Source Qualifier      Target

number(p,s)     decimal                 number(p,s)


-937.13          -937.13                    -9.4e+02


I want the exact same value in the target as well.


Thanks in advance for the help.



More Like This

  • Retrieving data ...

Bookmarked By (0)


  • Correct Answers - 10 points
  • Helpful Answers - 5 points