Cloud Data Integration Connectors All Products
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.
If you enter date and timestamp columns in the
SQL Querysource property, the mapping fails with the following error message:
The Secure Agent does not remove the external table names from the list of target objects available in the Target transformation.
When you select an Amazon Redshift ODBC connection as source and select an external table as a source object, the data preview fails.
If a field contains a Date or Datetime data type, the
Data Previewtab displays an offset value of +4 hours to the value of the field.
If you select the source type as query and do not map all the fields in the
Field Mappingtab, the task fails with the following error message:
If you select the value of the
Operationtarget property as upsert and run a mapping, the Secure Agent performs an update operation instead of an upsert operation.
Amazon Redshift V2 Connector does not support the key-range partitioning for a column of the Date/time data type.