Table of Contents

Search

  1. Version 10.2.2
  2. Version 10.2.1
  3. Version 10.2
  4. Version 10.1.1
  5. Version 10.1

PowerExchange for Amazon Redshift

PowerExchange for Amazon Redshift

Effective in version 10.2.2, PowerExchange for Amazon Redshift has the following changes:
  • The names of the following advanced properties for an Amazon Redshift data object write operations are changed:
    Old Property Name
    New Property Name
    Null value for CHAR and VARCHAR data types
    Require Null Value For Char and Varchar
    Wait time in seconds for file consistency on S3
    WaitTime In Seconds For S3 File Consistency
    Turn on S3 Server Side Encryption
    S3 Server Side Encryption
    Turn on S3 Client Side Encryption
    S3 Client Side Encryption
    Prefix to retain staging files on S3
    Prefix To Retain For Staging Files On S3
  • The default value for the following Unload command is changed:
    Unload Command
    Old Default Value
    New Default Value
    DELIMITER
    pipe (|)
    \036
  • The default values for the following Copy commands are changed:
    Copy Command
    Old Default Value
    New Default Value
    DELIMITER
    pipe (|)
    \036
    QUOTE
    double quote (")
    \037
  • When you import an Amazon Redshift table in the Developer Tool, you cannot add nullable columns in the table as primary keys.
    Previously, you could add nullable columns in the table as primary keys in the Developer Tool.
For more information, see the
Informatica PowerExchange for Amazon Redshift 10.2.2 User Guide
.


Updated December 18, 2019