PowerExchange Adapters for Informatica 10.1
- PowerExchange Adapters for Informatica 10.1
- All Products
If any schema in the Cassandra database contains a user defined type (UDT), the Cassandra ODBC driver does not list the tables from which you can import the metadata.
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.
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.