Table of Contents

Search

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

PowerExchange Adapters for Informatica Release Notes

PowerExchange Adapters for Informatica Release Notes

PowerExchange for Microsoft Azure SQL Data Warehouse (10.5)

PowerExchange for Microsoft Azure SQL Data Warehouse (10.5)

Fixed Issues

The following table describes fixed issues:
Bug
Description
BDM-28917
When the source data contains a slash
'\'
and you create a mapping to read the source data and retain the default quote character,
0x1f
, the mapping fails with the following error on the Databricks Spark engine:
SEVERE: Exception: com.microsoft.sqlserver.jdbc.SQLServerException: HdfsBridge::recordReaderFillBuffer - Unexpected error encountered filling record reader buffer: HadoopExecutionException: Could not find a delimiter after string delimiter."

Known Issues

The following table describes known issues:
Bug
Description
OCON-28603
When you use Azure Active Directory authentication to connect to Microsoft Azure SQL Data Warehouse, the test connection fails.
OCON-22851
When you use an ODBC data source to connect to Microsoft Azure SQL Data Warehouse and if the imported metadata contains special characters, the mapping fails.
OCON-22639
When you run a dynamic mapping that reads date, datetime, or smalldatetime fields from a source and creates an Azure SQL Data Warehouse target at run time, the mapping fails to run on the Databricks Spark engine.
OCON-17119
When you use the default values for field delimiter or quote character in advance source or target properties, mappings fail with incompatible data types or precision errors or the Data Integration Service writes incorrect data to the target.
OCON-12973
When you run a mapping that contains unconnected ports on the Hive engine, the mapping might fail or data corruption might happen.
OCON-12844
When you upsert or update data to Microsoft Azure SQL Data Warehouse and more than one column in the source table contains same value as the target column on which the primary key is defined, the Data Integration Service updates data incorrectly.

Third-Party Known Issues

The following table describes third-party known issues:
Bug
Description
OCON-25249
When you use the Microsoft ODBC Driver 17, mappings fail on Red Hat Enterprise Linux 8 with the following error:
"Data Transport Error, Origin :[IProxyDTMService :: deinitDTM RPC]"
Microsoft ticket number - 121010826001644

0 COMMENTS

We’d like to hear from you!