data type conversion - Number datatype in informatica is converting the number into exponential form -

my problem informatica mapping converting number of form 8000196005072015 form 8.000196005072015e+15.the precession of number datatype field set @ 50 , scale set 0. how can prevent happening without trimming data(8000196005072015).

thanks

there important difference between decimal , double datatypes in powercenter:

• decimal – fixed-point representation of real numbers,
• double – floating-point representation of real numbers.

however, defining decimal port not automatically mean integration service treat values passing though port fixed-point numbers.

port datatype | precision |  high precision               |           |   off  |   on --------------------------------------------- decimal       |   0-28    | double | decimal decimal       |  on 28  | double | double 

to work decimal values following conditions have met:

1. the datatype of port decimal and
2. the precision of port 28 or less and
3. the session option enable high precision enabled.