You can pass decimal and double data from sources to targets and perform transformations on decimal and double data.
The transformation language supports the following data types:
Decimal
Precision 1 to 28 digits, scale 0 to 28
. You cannot use decimal values with scale greater than precision or a negative precision. Transformations display any range you assign to a Decimal data type, but the PowerCenter Integration Service supports precision only up to 28 digits.
When you enable high precision and the port precision is greater than 28 digits, the PowerCenter Integration Service stores the result as a double.