Table of Contents

Search

  1. Preface
  2. Part 1: Version 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

Port-to-Port Data Conversion

Port-to-Port Data Conversion

Effective in version 9.6.0, the Data Integration Service uses the conversion functions in the transformation language to perform port-to-port conversions between transformations. The Data Integration Service performs port-to-port conversions when you pass data between ports with different datatypes. If the data that you pass is not valid for the conversion datatype, a transformation row error occurs.
Previously, the Data Integration Service did not use the transformation functions for port-to-port conversions. The Data Integration Service used a separate algorithm. If the data that you passed contained data that was not valid for the conversion datatype, the Data Integration Service dropped the value and used a substitute value.
Upgraded mappings that use port-to-port data conversion might produce different output data. For example, a mapping in a previous version produced the following output:
"0.377777","0.527777","0.000000","0.250000","0.000000","0.377777","0.250000"
After you upgrade, the same mapping might produce the following output:
"0.377777","0.527777","0","0.25","0","0.377777","0.25"


Updated September 25, 2020