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 Teradata Parallel Transporter API
  31. PowerExchange for Twitter
  32. PowerExchange for Web Content-Kapow Katalyst
  33. Informatica Global Customer Support

PowerExchange Adapters for Informatica Release Notes

PowerExchange Adapters for Informatica Release Notes

PowerExchange for Cassandra Third-Party Limitations

PowerExchange for Cassandra Third-Party Limitations

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.