Table of Contents

Search

  1. Abstract
  2. 2020 - August
  3. 2020 - July
  4. 2020 - April
  5. 2020 - February
  6. 2020 - January
  7. 2019 - November
  8. 2019 - September
  9. 2019 - August
  10. 2019 - July
  11. 2019 - June
  12. 2019 - May
  13. 2019 - April
  14. 2019 - March
  15. Informatica Global Customer Support

Connector Release Notes

Connector Release Notes

Amazon Redshift V2 Connector Known Limitations

Amazon Redshift V2 Connector Known Limitations

The following table describes known limitations:
CR
Description
CCON-18186
The
Data Preview
tab displays empty values for the fields with Boolean data type.
CCON-17808
If you enter date and timestamp columns in the
SQL Query
source property, the mapping fails with the following error message:
READER_1_1_1> AMAZONREDSHIFT_10000 [2019-06-08 17:33:00.080] [FATAL] Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff] READER_1_1_1> CMN_1761 [2019-06-08 17:33:00.080] Timestamp Event: [Sat Jun 08 17:33:00 2019] READER_1_1_1> JAVA PLUGIN_1762 [2019-06-08 17:33:00.080] [ERROR] com.informatica.cci.cloud.client.impl.CCIClientExceptionImpl: Unable to get result data: Adapter read method has returned failure.
CCON-16558
If you select
Multiple Objects
as the source type in an
elastic mapping
, the mapping fails with the following error message:
AmazonRedshiftBDMAdapter: [Amazon](500310) Invalid operation: column qa3.p_id does not exist;
CCON-14646
The Secure Agent does not remove the external table names from the list of target objects available in the Target transformation.
CCON-14451
When you select an Amazon Redshift ODBC connection as source and select an external table as a source object, the data preview fails.
CCON-13217
If a field contains a Date or Datetime data type, the
Data Preview
tab displays an offset value of +4 hours to the value of the field.
CCON-13053
If you select the source type as query and do not map all the fields in the
Field Mapping
tab, the task fails with the following error message:
The number of fields in the row do not match the num. of fields projected :54. Using ESCAPE Option may help.
CCON-11991
If you select the value of the
Operation
target property as upsert and run a mapping, the Secure Agent performs an update operation instead of an upsert operation.
CCON-11332
Amazon Redshift V2 Connector does not support the key-range partitioning for a column of the Date/time data type.


Updated August 02, 2020