Effective in version 10.0, some transformations support the Decimal data type with a precision of up to 38 digits. The decimal data type has a precision of 1 to 38 digits and a scale of 0 to 38. All other transformations support the Decimal data type with a precision of up to 28 digits.
For transformations that support the Decimal data type of precision up to 38 digits, when the target contains a precision that is greater than 38 digits and has high precision enabled, the Data Integration Service stores the result as a double.
For more information, see the "Data Type Reference" appendix in the