Changed behavior

Informatica enforces connection-level permissions for listing and selecting connection assets. You can now granularly control who can view, edit, or delete specific connections based on the permissions. This update improves security and access control by restricting visibility and access to connection assets based on your assigned permissions, preventing unauthorized users from viewing or using connections.

Previously, you could see the names of all connections in the organization, even if you didn't have specific permissions for those connections.

For more information about the required permissions, see Permissions in the Administrator help.

When you read from external tables, the string data type is mapped to varchar data type.

Previously, the columns of string data type were ignored.

You can configure an error threshold in the Stop on Error session property in a mapping task.

When you set an error threshold, the mapping task continues to run until the cumulative errors reach or exceed the threshold. As the mapping task runs in batch mode, the cumulative errors might exceed the threshold before the task fails.

Previously, the error threshold was not honored.

This changed behavior doesn't apply to mapping tasks that are based on mappings in advanced mode.

When you use the DB2 subtype in the connection and select the Truncate Target option in the Target properties of a mapping, the mapping runs the TRUNCATE TABLE query first. If the TRUNCATE TABLE query fails, the mapping runs the DELETE query.

Previously, the DELETE query was always run when the Truncate Target option was selected.

The advanced target property Iceberg Spark Properties is renamed to Iceberg Advanced Properties. However, there is no impact on its functionality.

Salesforce Data Cloud Connector is renamed to Salesforce Data 360 Connector.

The Password/PAT connection property for standard authentication is renamed to the Password connection property. If you want to use a programmatic access token generated in Snowflake, use the Programmatic Access Token authentication type to connect to Snowflake.

Previously, if your connection used standard authentication with a programmatic access token, the connection is not impacted.

However, Informatica recommends that you use authorization code, key pair, client credentials, or programmatic access token authentication to connect to Snowflake instead of using standard authentication.