Table of Contents

Search

  1. Informatica Bug Tracking System Change
  2. PowerExchange for Amazon Redshift
  3. PowerExchange for Amazon S3
  4. PowerExchange for Cassandra
  5. PowerExchange for DataSift
  6. PowerExchange for Facebook
  7. PowerExchange for Greenplum
  8. PowerExchange for HBase
  9. PowerExchange for HDFS
  10. PowerExchange for Hive
  11. PowerExchange for JD Edwards EnterpriseOne
  12. PowerExchange for LDAP
  13. PowerExchange for LinkedIn
  14. PowerExchange for MapR-DB
  15. PowerExchange for Microsoft Azure Blob Storage
  16. PowerExchange for Microsoft Azure SQL Data Warehouse
  17. PowerExchange for Microsoft Dynamics CRM
  18. PowerExchange for MongoDB
  19. PowerExchange for Netezza
  20. PowerExchange for OData
  21. PowerExchange for Salesforce
  22. PowerExchange for SAP NetWeaver
  23. PowerExchange for Tableau
  24. PowerExchange for Teradata Parallel Transporter API
  25. PowerExchange for Twitter
  26. PowerExchange for Web Content-Kapow katalyst
  27. Informatica Global Customer Support

PowerExchange Adapters for Informatica Release Notes

PowerExchange Adapters for Informatica Release Notes

PowerExchange for Amazon Redshift Known Limitations (10.1.1 Update 2 and 10.1.1 Update 1)

PowerExchange for Amazon Redshift Known Limitations (10.1.1 Update 2 and 10.1.1 Update 1)

The following table describes known limitations:
Bug
Description
OCON-8022
If you import an Amazon Redshift table that has a single quote (') in the column name, the mapping fails with the following error message:
[LDTM_0072] [Amazon](500051) ERROR processing query/statement. Error: Parsing failed, Query: unload ('SELECT "adpqa"."sq_col"."id'" FROM "adpqa"."sq_col"') TO 's3://infa.qa.bucket/0b0ad503-1c2c-4514-95ac-85a5adb71b3b1489385038407/sq_col_' credentials 'aws_access_key_id=********;aws_secret_access_key=********' ESCAPE DELIMITER ','
OCON-8020
If you import an Amazon Redshift table that has a question mark (?) in the column name, the read and write operations fail with the following error message:
[LDTM_0072] [Amazon](500310) Invalid operation: syntax error at or near ""."";
OCON-7965
When you run an Amazon Redshift mapping on the Blaze engine to read data from or write data to an Amazon Redshift cluster that requires Version 4 authentication, the mapping fails. This issue occurs if you use the Hortonworks 2.3 distribution.
OCON-7909
When you run an Amazon Redshift mapping on the Blaze engine to read data from or write data to an Amazon Redshift cluster that requires Version 4 authentication, the mapping fails. This issue occurs if you use the MapR 5.2 distribution.
OCON-7322
If you import an Amazon Redshift table that has a single quote (') or a backslash (\) in the table name, the read and write operations fail.