PowerExchange Adapters for Informatica 10.2
- PowerExchange Adapters for Informatica 10.2
- All Products
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)
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)
The performance of reading data from a Cassandra source is slow even when you increase the number of partitions.
The Cassandra ODBC driver does not support null values in collections and reports non-key columns in virtual tables as not nullable.
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.
The performance of writing data to a Cassandra target is slow when you use Cassandra ODBC driver 2.4.1 when compared to 2.0.18.