Table of Contents


  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

Decimal and Double Data Types

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:
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.
Double-precision floating-point numeric value.
You can edit the precision and scale. The scale must be less than or equal to the precision.

Updated July 02, 2020