Table of Contents

Search

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

PowerExchange Adapters for PowerCenter®

PowerExchange Adapters for PowerCenter®

This section describes new PowerCenter adapter features in version 10.1.1.

PowerExchange for Amazon Redshift

Effective in version 10.1.1, you can perform the following tasks with PowerExchange for Amazon Redshift:
  • You can configure partitioning for Amazon Redshift sources and targets. You can configure the partition information so that the PowerCenter Integration Service determines the number of partitions to create at run time.
  • You can include a Pipeline Lookup transformation in a mapping.
  • The PowerCenter Integration Service can push expression, aggregator, operator, union, sorter, and filter functions to Amazon Redshift sources and targets when the connection type is ODBC and the ODBC Subtype is selected as Redshift.
  • You can configure advanced filter properties in a mapping.
  • You can configure pre-SQL and post-SQL queries for source and target objects in a mapping.
  • You can configure a Source transformation to select distinct rows from the Amazon Redshift table and sort data.
  • You can parameterize source and target table names to override the table name in a mapping.
  • You can define an SQL query for source and target objects in a mapping to override the default query. You can enter an SQL statement supported by the Amazon Redshift database.
For more information, see the
Informatica 10.1.1 PowerExchange for Amazon Redshift User Guide for PowerCenter
.

PowerExchange for Cassandra

Effective in version 10.1.1, PowerExchange for Cassandra supports the following features:
  • You can use the following advanced ODBC driver configurations with PowerExchange for Cassandra:
    • Load balancing policy. Determines how the queries are distributed to nodes in a Cassandra cluster based on the specified DC Aware or Round-Robin policy.
    • Filtering. Limits the connections of the drivers to a predefined set of hosts.
  • You can enable the following arguments in the ODBC driver to optimize the performance:
    • Token Aware. Improves the query latency and reduces load on the Cassandra node.
    • Latency Aware. Ignores the slow performing Cassandra nodes while sending queries.
    • Null Value Insertion. Enables you to specify null values in an INSERT statement.
    • Case Sensitive. Enables you to specify schema, table, and column names in a case-sensitive fashion.
  • You can process Cassandra sources and targets that contain the date, smallint, and tinyint data types.
For more information, see the
Informatica PowerExchange for Cassandra 10.1.1 User Guide for PowerCenter
.

PowerExchange for Vertica

Effective in version 10.1.1, PowerExchange for Vertica supports compressing data in GZIP format. When you use bulk mode to write large volumes of data to a Vertica target, you can configure the session to create a staging file. On UNIX operating systems, when you enable file staging, you can also compress the data in a GZIP format. By compressing the data, you can reduce the size of data that is transferred over the network and improve session performance.
To compress data, you must re-register the PowerExchange for Vertica plug-in with the PowerCenter repository.
For more information, see the
Informatica PowerExchange for Vertica 10.1.1 User Guide for PowerCenter
.


Updated September 25, 2020