Perform the following tasks after your organization is upgraded to the May 2024 release.
Mappings in SQL ELT mode
After the upgrade, mappings in SQL ELT mode that contain sources, targets, or lookup objects with fields of an unsupported data type are marked invalid in the Mapping Designer. If you use a parameterized source, target, or lookup object, mapping tasks based on mappings in SQL ELT mode are also marked invalid if the parameter is resolved with an object that contains fields of an unsupported data type.
For example, if a mapping contains a Snowflake source with a TIMESTAMPTZ column, the mapping is marked invalid because Data Integration has no corresponding transformation data type.
This change is due to enhanced validation to check for unsupported data types at design time.
To make the mapping valid, perform one of the following actions after the upgrade:
•Remove the affected fields from the mapping.
•Select a different object.
•For source and lookup objects, use a custom query to extract the data.
Saxon libraries upgraded to version 10.8
Taskflows use the upgraded version 10.8 of the Saxon libraries. Version 10.8 of the Saxon libraries offers improved security, performance, and scalability. After you upgrade to the May 2024 release, you must republish all the taskflows to use version 10.8 of the Saxon libraries. If you do not republish the taskflows, Data Integration continues to use the earlier version of the Saxon libraries.
For information about the changed behaviors and known issues related to the version upgrade, see the Informatica Knowledge Base article 000205484.