Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.4.1
  3. Part 2: Version 10.4.0
  4. Part 3: Version 10.2.2
  5. Part 4: Version 10.2.1
  6. Part 5: Version 10.2
  7. Part 6: Version 10.1.1
  8. Part 7: Version 10.1

PowerExchange Adapters for PowerCenter

PowerExchange Adapters for PowerCenter

This section describes new PowerCenter adapter features in version 10.2 HotFix 2.

PowerExchange for Amazon Redshift

Effective in version 10.2 HotFix 2, you can retain the null values when you read data from Amazon Redshift.
For more information, see the
Informatica PowerExchange for Amazon Redshift 10.2 HotFix 2 User Guide for PowerCenter
.

PowerExchange for Google BigQuery

Effective in version 10.2 HotFix 2, PowerExchange for Google BigQuery includes the following new features:
  • You can configure a custom SQL query to configure a Google BigQuery source.
  • You can configure a SQL override to override the default SQL query used to extract data from the Google BigQuery source.
  • You can specify a quote character that defines the boundaries of text strings in a .csv file. You can configure parameters such as single quote or double quote.
  • You can configure full pushdown optimization to push the transformation logic to Google BigQuery when you use the ODBC connection type.
    For information about the operators and functions that the PowerCenter Integration Service can push to Google BigQuery, see the
    Informatica PowerCenter 10.2 HotFix 2 Advanced Workflow Guide
    .
For more information, see the
Informatica PowerExchange for Google BigQuery 10.2 HotFix 2 User Guide for PowerCenter
.

PowerExchange for Kafka

Effective in version 10.2 HotFix 2, PowerExchange for Kafka includes the following new features:
  • You can import a Kafka source or target definition in Avro format.
  • You can configure SSL configuration properties to securely connect to Kafka.
  • You can preview data of a Kafka source or target definition.
For more information, see the
Informatica PowerExchange for Kafka 10.2 HotFix 2 User Guide for PowerCenter
.

PowerExchange for Microsoft Azure SQL Data Warehouse V3

Effective in version 10.2 HotFix 2, PowerExchange for Microsoft Azure SQL Data Warehouse V3 includes the following new features:
  • You can use custom queries when you read a source object.
  • You can override the source object and the source object schema in the source session properties. The source object and the source object schema defined in the source session properties take the precedence.
  • You can override the target object and the target object schema in the target session properties. The target object and the target object schema defined in the target session properties take the precedence.
  • You can create a mapping to read the real-time or changed data from a Change Data Capture (CDC) source and load data into Microsoft Azure SQL Data Warehouse. You must select
    Data Driven
    as the target operation to capture changed data. You can resume the extraction of changed data from the point of interruption when a mapping fails or is stopped before completing the session.
  • You can utilize the following pushdown functions when you use an ODBC connection to connect to Microsoft Azure SQL Data Warehouse:
    • Date_diff()
    • First()
    • Instr()
    • Last()
    • MD5()
    • ReplaceChr()
    • ReplaceStr()
  • To enhance the performance, you can compress staging files in the .gzip format when you write to a target object.
For more information, see the
Informatica PowerExchange for Microsoft Azure SQL Data Warehouse V310.2 HotFix 2 User Guide for PowerCenter
.

PowerExchange for Salesforce

Effective in version 10.2 HotFix 2, PowerExchange for Salesforce includes the following new features:
  • You can use version 43.0, 44.0, and 45.0 of Salesforce API to create a Salesforce connection and access Salesforce objects.
  • You can enable primary key chunking for queries on a shared object that represents a sharing entry on the parent object. Primary key chunking is supported for shared objects only if the parent object is supported. For example, if you want to query on CaseHistory, primary key chunking must be supported for the parent object Case.
  • You can create assignment rules to reassign attributes in records when you insert, update, or upsert records for Lead and Case target objects using the standard API.
  • You can parameterize the Salesforce service URL for standard and OAuth connection.
For more information, see the
Informatica PowerExchange for Salesforce 10.2 HotFix 2 User Guide for PowerCenter
.

PowerExchange for Snowflake

Effective in version 10.2 HotFix 2, PowerExchange for Snowflake includes the following new features:
  • You can configure the PowerCenter Integration Service to write rejected records to a rejected file. If the file already exists, the PowerCenter Integration Service appends the rejected records to that file. If you do not specify the rejected file path, the PowerCenter Integration Service does not write the rejected records.
  • You can use an Update Strategy transformation in a mapping to insert, update, delete, or reject data in Snowflake targets. When you configure an Update Strategy transformation, the
    Treat Source Rows As
    session property is marked
    Data Driven
    by default.
  • You can use the SQL editor to create or edit the pre-SQL and post-SQL statements in the Snowflake source and target sessions.
For more information, see the
Informatica PowerExchange for Snowflake 10.2 HotFix 2 User Guide for PowerCenter
.


Updated August 28, 2020