Table of Contents

Search

  1. Abstract
  2. PowerExchange for Amazon Redshift
  3. PowerExchange for Amazon S3
  4. PowerExchange for Cassandra
  5. PowerExchange for Google BigQuery
  6. PowerExchange for Google Cloud Storage
  7. PowerExchange for Greenplum
  8. PowerExchange for HBase
  9. PowerExchange for HDFS
  10. PowerExchange for Hive
  11. PowerExchange for JDBC V2
  12. PowerExchange for JD Edwards EnterpriseOne
  13. PowerExchange for Kudu
  14. PowerExchange for LDAP
  15. PowerExchange for Microsoft Azure Blob Storage
  16. PowerExchange for Microsoft Azure Cosmos DB SQL API
  17. PowerExchange for Microsoft Azure Data Lake Storage Gen1
  18. PowerExchange for Microsoft Azure Data Lake Storage Gen2
  19. PowerExchange for Microsoft Azure SQL Data Warehouse
  20. PowerExchange for MongoDB
  21. PowerExchange for Netezza
  22. PowerExchange for OData
  23. PowerExchange for Salesforce
  24. PowerExchange for SAP NetWeaver
  25. PowerExchange for Snowflake
  26. PowerExchange for Teradata
  27. Informatica Global Customer Support

PowerExchange Adapters for Informatica Release Notes (10.5.0.1)

PowerExchange Adapters for Informatica Release Notes (10.5.0.1)

PowerExchange for Snowflake (10.5)

PowerExchange for Snowflake (10.5)

Fixed Issues

The following table describes fixed issues:
Bug
Description
OCON-26475
Snowflake mappings that run on the Amazon EMR 6.1 cluster fail with the following error:
NoClassDefFoundError: scala/Product$class
OCON-26420
Snowflake mappings that run on the Databricks Spark engine version 7.2 fail with the following error:
java.lang.NoSuchMethodError: scala.Predef$.refArrayOps
OCON-26285
If the length of the SQL override in a Snowflake mapping exceeds 4000 characters, the mapping fails.
OCON-22177
When you run a mapping on the Spark engine to write data to a Snowflake target and the target table and column names are not in uppercase letters, the mapping fails.
OCON-21723
When you configure pushdown optimization in a mapping with the update as update, update else insert, or delete operation, the pushdown query is not generated.

Third-Party Fixed Issues

The following table describes fixed issues:
Bug
Description
OCON-24679
The COPY command for external table mappings fails to run on the Spark engine.
Snowflake reference number: 00112958
OCON-22941
When you run a Snowflake mapping on the Spark engine and the data contains case-sensitive tables, the mapping fails.
OCON-22465
When you run a mapping on the Spark engine to read from a Snowflake source table that does not contain data, the mapping fails with the following error:
java.util.NoSuchElementException: head of empty list
OCON-17317
When you use Snowflake jars, version 2.11-2.4.3, the performance of the read operation of a Snowflake mapping on the Spark engine drops by 1.5X when compared to Snowflake jars of version 2.11-2.3.1.
Snowflake reference number: 00034954

Known Issues

The following table describes known issues:
Bug
Description
OCON-25386
When you run a mapping with source pushdown optimization enabled and the mapping includes a Sorter transformation, the mapping fails.
OCON-16608
When you run a mapping on the Spark engine to write data to a Snowflake target, and the data contains the Binary data type, the mapping fails.

Third-Party Known Issues

The following table describes third-party known issues:
Bug
Description
OCON-26899
When you import Snowflake tables, the table type reflects as TABLE rather than EXTERNAL_TABLE in the package explorer.
Snowflake reference number: 00165157
OCON-12175
When you run a mapping in the native environment to read large volumes of data from Snowflake, the mapping fails with an out-of-memory error.
Workaround: Increase the Java heap memory size in the Data Integration Service properties, and restart the Data Integration Service.
Snowflake reference number: 00028631
OCON-11651
When you run a mapping on the Spark engine to write data of the Time data type, the Data Integration Service does not write the data to the Snowflake table even though the mapping runs successfully.
Snowflake reference number: 00033380