Table of Contents

Search

  1. Abstract
  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 Data Lake Store
  17. PowerExchange for Microsoft Azure SQL Data Warehouse
  18. PowerExchange for Microsoft Dynamics CRM
  19. PowerExchange for MongoDB
  20. PowerExchange for Netezza
  21. PowerExchange for OData
  22. PowerExchange for Salesforce
  23. PowerExchange for SAP NetWeaver
  24. PowerExchange for Snowflake
  25. PowerExchange for Tableau
  26. PowerExchange for Teradata Parallel Transporter API
  27. PowerExchange for Twitter
  28. PowerExchange for Web Content-Kapow Katalyst
  29. Informatica Global Customer Support

PowerExchange Adapters for Informatica Release Notes

PowerExchange Adapters for Informatica Release Notes

PowerExchange for Cassandra Third-Party Limitations (10.2.1)

PowerExchange for Cassandra Third-Party Limitations (10.2.1)

The following table describes third-party known limitations:
Bug
Description
OCON-11307
The Cassandra database stores values of the Float data type in the exponential format. The value of the Float data type read by the Informatica Cassandra ODBC driver is not the same as the value of the Float data type in the Cassandra database because the Informatica Cassandra ODBC driver maps the Float data type to SQL_Real. (397018)
OCON-11206
The Cassandra database does not allow periods in column names. PreSQL or PostSQL queries generated with the SQL Editor fail with a syntax error because the SQL Editor prefixes periods to column names to qualify column names with table names.
Workaround: Do not qualify column names with table names in queries. (397187)
OCON-7787
The performance of reading data from a Cassandra source is slow even when you increase the number of partitions.
OCON-7027
The Cassandra ODBC driver does not support null values in collections and reports non-key columns in virtual tables as not nullable.
OCON-7023
If you use a single SQL statement to write multiple rows to a Cassandra target and you bind the default value to the first row, the insert statement fails.
Workaround: Use null instead of the default value.