Designer Guide

10.4.1
- 10.5.6
- 10.5
- 10.4.0

Back Next

Decimal and Double Data Types

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.; For transformations that support precision up to 38 digits, the precision is 1 to 38 digits, and the scale is 0 to 38.
For transformations that support precision up to 28 digits, the precision is 1 to 28 digits, and the scale is 0 to 28.
You cannot use decimal values with a scale greater than the precision or with a negative precision. Transformations display any range that you assign to the Decimal data type, but the Data Integration Service supports precision only up to 38 digits or 28 digits depending on the transformation.; When you enable high precision and the port precision is greater than 38 digits or 28 digits, depending on the transformation, the Data Integration Service stores the result as a double.; When you enable high precision and the port precision is greater than 28 digits, the PowerCenter Integration Service stores the result as a double.; For transformations that support precision up to 38 digits, the precision is 1 to 38 digits, and the scale is 0 to 38.
For transformations that support precision up to 28 digits, the precision is 1 to 28 digits, and the scale is 0 to 28.
You cannot use decimal values with a scale greater than the precision or with a negative precision. Transformations display any range that you assign to the Decimal data type, but the Data Integration Service supports precision only up to 38 digits or 28 digits depending on the transformation.; When you enable high precision and the port precision is greater than 38 digits or 28 digits, depending on the transformation, the Data Integration Service stores the result as a double.

Double: Double-precision floating-point numeric value.
You can edit the precision and scale. The scale must be less than or equal to the precision.

Transformation Data Types

Decimal and Double Values in Calculations

Rounding Methods for Double Values

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal