Skip navigation
Contact Us
877 Views 2 Replies Latest reply: Dec 24, 2012 10:13 AM by kommireddy.nikhila@gmail.com RSS
kommireddy.nikhila@gmail.com 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.

Example:

 

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.

 

Nikhila.

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

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