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:
Integration At Scale is available for preview. Preview functionality is supported but is unwarranted and is not production-ready. Informatica recommends that you use in non-production environments only. Informatica intends to include the preview functionality in an upcoming release for production use, but might choose not to in accordance with changing market or technical circumstances. For more information, contact Informatica Global Customer Support. To use the functionality, your organization must have the appropriate licenses.
CR
Description
CBDM-3385
If you use server-side encryption with KMS in an
elastic mapping
, the mapping fails with the following error message:
com.amazonaws.services.s3.model.AmazonS3Exception: The encryption method specified is not supported.
CCON-16666
When you run an
elastic mapping
, the pre-SQL commands are executed after reading the data from the source, and the post-SQL commands are executed before writing the data to the target.
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