PowerExchange Adapters
This section describes new PowerExchange adapter features in version 10.1.1
PowerExchange® Adapters for Informatica
This section describes new Informatica adapter features in version 10.1.1.
PowerExchange for Amazon Redshift
Effective in version 10.1.1, you can enable PowerExchange for Amazon Redshift to run a mapping on the Blaze engine. When you run the mapping, the Data Integration Service pushes the mapping to a Hadoop cluster and processes the mapping on the Blaze engine, which significantly increases the performance.
For more information, see the Informatica PowerExchange for Amazon Redshift 10.1.1 User Guide.
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.
PowerExchange for HBase
Effective in version 10.1.1, you can enable PowerExchange for HBase to run a mapping on a Blaze or Spark engine. When you run the mapping, the Data Integration Service pushes the mapping to a Hadoop cluster and processes the mapping on the selected engine, which significantly increases the performance.
For more information, see the Informatica PowerExchange for HBase 10.1.1 User Guide.
PowerExchange for Hive
Effective in version 10.1.1, you can configure the Lookup transformation on Hive data objects in mappings in the native environment.
For more information, see the Informatica PowerExchange for Hive 10.1.1 User Guide.
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.