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:

After you upgrade, the same mapping might produce the following output: