Table of Contents

Search

  1. Preface
  2. Part 1: 10.2
  3. Part 2: Version 10.1.1
  4. Part 3: Version 10.1
  5. Part 4: Version 10.0
  6. Part 5: Version 9.6.1
  7. Part 6: Version 9.6.0

Mappings with the Decimal 38 Data Type

Mappings with the Decimal 38 Data Type

Effective in version 10.0, if you run a mapping that contains fields with precision greater than 28 but less than or equal to 38 in high precision mode, the Data Integration Service processes a precision of up to 38 digits. There is no behavior change if the precision is greater than 38 digits post upgrade.
The following table describes the post-upgrade behavior based on the applicable precision:
Precision
Previous
10.0
Greater than 28 but less than or equal to 38
Double
Decimal
Over 38
Double
Double
For example, you have the following source data:
12345678901234567890123456789012345678
Previously, the target contains the following data:
12345678901234500000000000000000000000
In 10.0, the target contains the following data:
12345678901234567890123456789012345678
For more information, see the "Data Type Reference" appendix in the
Informatica 10.0 Developer Tool Guide
.


Updated August 28, 2020