PowerExchange Adapters for Informatica
This section describes changes to Informatica adapters in version 10.2.2.
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.
PowerExchange for Amazon S3
Effective in version 10.2.2, PowerExchange for Amazon S3 has the following changes:
- •The name of the Download S3 File in Multiple Parts advanced source session property is changed to Multiple Download Threshold.
- •You do not need to add the GetBucketAcl permission in the Amazon S3 bucket policy to connect to Amazon S3.
Previously, you had to add the GetBucketAcl permission in the Amazon S3 bucket policy to connect to Amazon S3.
For more information, see the Informatica PowerExchange for Amazon S3 10.2.2 User Guide.
PowerExchange for Google Analytics
Effective in version 10.2.2, PowerExchange for Google Analytics installs with the Informatica Services.
Previously, PowerExchange for PowerExchange for Google Analytics had a separate installer.
For more information, see the Informatica PowerExchange for Google Analytics 10.2.2 User Guide.
PowerExchange for Google Cloud Storage
Effective in version 10.2.2, PowerExchange for Google Cloud Storage installs with the Informatica Services.
Previously, PowerExchange for PowerExchange for Google Cloud Storage had a separate installer.
For more information, see the Informatica PowerExchange for Google Cloud Storage 10.2.2 User Guide.
PowerExchange for HBase
Effective in version 10.2.2, you must run a mapping on the Spark engine to look up data in an HBase resource.
Previously, you could run the mapping in the native environment or on the Spark engine to look up data in an HBase resource.
For more information, see the Informatica PowerExchange for HBase 10.2.2 User Guide.
PowerExchange for HDFS
Effective in version 10.2.2, When you run a mapping on the Blaze engine to write data to an HDFS flat file target, the Data Integration Service creates the target files with the following naming convention:
<FileName>-P1, <FileName>-P2,....<FileName>-P100....<FileName>-PN
Previously, the target files were generated in the following format:
Target1.out, Target2.out....Target<PartitionNo>.out
For more information, see the Informatica PowerExchange for HDFS 10.2.2 User Guide.
PowerExchange for Hive
Effective in version 10.2.2, the User Name property in a Hive connection is renamed to LDAP username.
PowerExchange for Microsoft Azure Blob Storage
Effective in version 10.2.2, you can navigate through the container structure when you import an object from Microsoft Azure Blob Storage and select objects from sub-directories. Previously, you could select objects present only in the container.
For more information, see the Informatica PowerExchange for Microsoft Azure Blob Storage 10.2.2 User Guide.