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