Cloud Data Integration Connectors All Products
When you use a view that you created on an external table, the mapping fails for numeric and character data types with the following error:
Internal error. The native type system does not support the data type [numeric(2,0)] in the native metadata field. Contact Informatica Global Customer Support.
When you run a query that contains a dollar ($) symbol and the identifier name is not enclosed within double quotes, the mapping fails with the following error:
Invalid operation: cannot insert multiple commands into a prepared statement
Workaround: Enclose the identifier name within double quotes or upgrade the Redshift JDBC jar.
Upgrade the Redshift JDBC jar to
RedshiftJDBC42-no-awssdk-22.214.171.1247.jarand the dependent jar to
antlr4-4.5.3.jar. Remove the existing Redshift JDBC jar
When the source type is multiple objects and you apply a filter condition on a related object, the mapping fails. (February 2021)
When you configure a source filter under
Query Optionson any field in the source object, the Secure Agent converts boolean values to zero in the target object. (February 2021)
When the source table name contains unicode or special characters and you select an existing target or create a target, the elastic mapping fails. (October 2020)