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.
R u using toad to view target data?
Open toad -- view menu-- toad options -- data grid -- data -- uncheck display large numbers in scientific notation