PowerExchange Adapters for Informatica
- PowerExchange Adapters for Informatica 10.4.0
- All Products
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 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 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.