Table of Contents

Search

  1. Abstract
  2. PowerExchange for Amazon Redshift
  3. PowerExchange for Amazon S3
  4. PowerExchange for Cassandra
  5. PowerExchange for Cassandra JDBC
  6. PowerExchange for DataSift
  7. PowerExchange for Facebook
  8. PowerExchange for Google Analytics
  9. PowerExchange for Google BigQuery
  10. PowerExchange for Google Cloud Storage
  11. PowerExchange for Greenplum
  12. PowerExchange for HBase
  13. PowerExchange for HDFS
  14. PowerExchange for Hive
  15. PowerExchange for JD Edwards EnterpriseOne
  16. PowerExchange for LDAP
  17. PowerExchange for LinkedIn
  18. PowerExchange for MapR-DB
  19. PowerExchange for Microsoft Azure Blob Storage
  20. PowerExchange for Microsoft Azure Cosmos DB SQL API
  21. PowerExchange for Microsoft Azure Data Lake Store
  22. PowerExchange for Microsoft Azure SQL Data Warehouse
  23. PowerExchange for Microsoft Dynamics CRM
  24. PowerExchange for MongoDB
  25. PowerExchange for Netezza
  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. PowerExchange for Twitter
  33. PowerExchange for Web Content-Kapow Katalyst
  34. Informatica Global Customer Support

PowerExchange Adapters for Informatica Release Notes

PowerExchange Adapters for Informatica Release Notes

PowerExchange for Microsoft Azure SQL Data Warehouse Known Limitations (10.2.2)

PowerExchange for Microsoft Azure SQL Data Warehouse Known Limitations (10.2.2)

The following table describes known limitations:
Bug
Description
OCON-19645
When you use an ODBC data source to connect to Microsoft Azure SQL Data Warehouse and if the imported metadata contains unicode or special characters, the mapping fails.
OCON-18423
When you run a mapping that reads or writes binary or varbinary data type columns, the mapping fails with the following error on the Databricks Spark engine:
<DTF-ThreadGroup-3-thread-43> WARNING: [LDTM_6009] Skipping translator [ImfDatabricksTargetTxTranslator] because it encountered the following exception: (write, com.informatica.platform.ldtm.flex.domains.databricks.BatchDatabricksEngine@4248e4bc) = java.lang.NullPointerException.
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.
OCON-10141
When you run a mapping on the Hive engine to read data from or write data to Microsoft Azure SQL Data Warehouse, the intermediate files get downloaded in the staging directory even if you cancel the mapping.
OCON-585
When an Azure table contains a bad record, the Data Integration Service fails the mapping instead of rejecting the bad record.