New Features (10.1.1 HotFix 1)
This section describes new features in version 10.1.1 HotFix 1.
Command Line Programs
This section describes new commands in version 10.1.1 HotFix 1.
infacmd dis Commands (10.1.1 HF1)
The following table describes new infacmd dis commands:
Command | Description |
|---|
disableMappingValidationEnvironment | Disables the mapping validation environment for mappings that are deployed to the Data Integration Service. |
enableMappingValidationEnvironment | Enables a mapping validation environment for mappings that are deployed to the Data Integration Service. |
setMappingExecutionEnvironment | Specifies the mapping execution environment for mappings that are deployed to the Data Integration Service. |
For more information, see the "Infacmd dis Command Reference" chapter in the Informatica 10.1.1 HotFix1 Command Reference.
infacmd mrs Commands (10.1.1 HF1)
The following table describes new infacmd mrs commands:
Command | Description |
|---|
disableMappingValidationEnvironment | Disables the mapping validation environment for mappings that you run from the Developer tool. |
enableMappingValidationEnvironment | Enables a mapping validation environment for mappings that you run from the Developer tool. |
setMappingExecutionEnvironment | Specifies the mapping execution environment for mappings that you run from the Developer tool. |
For more information, see the "Infacmd mrs Command Reference" chapter in the Informatica 10.1.1 HotFix1 Command Reference.
infacmd ps Command
The following table describes a new infacmd ps command:
Command | Description |
|---|
restoreProfilesAndScorecards | Restores profiles and scorecards from a previous version to version 10.1.1 HotFix 1. |
For more information, see the "infacmd ps Command Reference" chapter in the Informatica 10.1.1 HotFix 1 Command Reference.
Informatica Analyst
This section describes new Analyst tool features in version 10.1.1 HotFix 1.
Profiles and Scorecards
This section describes new Analyst tool features for profiles and scorecards.
Invalid Rows Worksheet
Effective in version 10.1.1 HotFix1, scorecard export results include invalid source rows after you choose the Data > All option in the Export data to a file dialog box.
For more information about scorecards, see the "Scorecards in Informatica Analyst" chapter in the Informatica 10.1.1 HotFix1 Data Discovery Guide.
PowerCenter
This section describes new PowerCenter features in version 10.1.1 HotFix 1.
Pushdown Optimization for Greenplum
Effective in version 10.1.1 HotFix 1, when the connection type is ODBC, the PowerCenter Integration Service can push TRUNC(DATE), CONCAT(), and TO_CHAR(DATE) functions to Greenplum using source-side and full pushdown optimization.
For more information, see the Informatica PowerCenter 10.1.1 HotFix 1 Advanced Workflow Guide.
Pushdown Optimization for Microsoft Azure SQL Data Warehouse
Effective in version 10.1.1 HotFix 1, when the connection type is ODBC, you can configure source-side or full pushdown optimization to push the transformation logic to Microsoft Azure SQL Data Warehouse.
For more information, see the Informatica PowerCenter 10.1.1 HotFix 1 Advanced Workflow Guide.
PowerExchange Adapters
This section describes new PowerExchange adapter features in version 10.1.1 HotFix 1.
PowerExchange Adapters for PowerCenter®
This section describes new PowerCenter adapter features in version 10.1.1 HotFix 1.
PowerExchange for Amazon Redshift
This section describes new PowerExchange for Amazon Redshift features in version 10.1.1 HotFix 1:
- • You can read data from or write data to the following regions:
- - Asia Pacific (Mumbai)
- - Canada (Central)
- - US East (Ohio)
- •PowerExchange for Amazon Redshift supports the asterisk pushdown operator (*) that can be pushed to the Amazon Redshift database by using source-side, target-side, or full pushdown optimization.
- •For client-side and server-side encryption, you can configure the customer master key ID generated by AWS Key Management Service (AWS KMS) in the connection.
For more information, see the Informatica 10.1.1 HotFix 1 PowerExchange for Amazon Redshift User Guide for PowerCenter.
PowerExchange for Amazon S3
This section describes new PowerExchange for Amazon S3 features in version 10.1.1 HotFix 1:
- • You can read data from or write data to the following regions:
- - Asia Pacific (Mumbai)
- - Canada (Central)
- - US East (Ohio)
- •For client-side and server-side encryption, you can configure the customer master key ID generated by AWS Key Management Service (AWS KMS) in the connection.
- •When you write data to the Amazon S3 buckets, you can compress the data in GZIP format.
- •You can override the Amazon S3 folder path when you run a mapping.
For more information, see the Informatica PowerExchange for Amazon S3 10.1.1 HotFix 1 User Guide for PowerCenter.
PowerExchange for Microsoft Azure Blob Storage
Effective in version 10.1.1 HotFix 1, you can use append blob type target session property to write data to Microsoft Azure Blob Storage.
For more information, see the Informatica PowerExchange for Microsoft Azure Blob Storage 10.1.1 HotFix 1 User Guide.
PowerExchange for Microsoft Azure SQL Data Warehouse
Effective in version 10.1.1 HotFix 1, you can use the following target session properties with PowerExchange for Microsoft Azure SQL Data Warehouse:
- •Update as Update. The PowerCenter Integration Service updates all rows as updates.
- •Update else Insert. The PowerCenter Integration Service updates existing rows and inserts other rows as if marked for insert.
- •Delete. The PowerCenter Integration Service deletes the specified records from Microsoft Azure SQL Data Warehouse.
For more information, see the Informatica PowerExchange for Microsoft Azure SQL Data Warehouse 10.1.1 HotFix 1 User Guide for PowerCenter.
PowerExchange for Microsoft Dynamics CRM
Effective in version 10.1.1 HotFix 1, you can use the following target session properties with PowerExchange for Microsoft Dynamics CRM:
- •Add row reject reason. Select to include the reason for rejection of rows to the reject file.
- •Alternate Key Name. Indicates whether the column is an alternate key for an entity. Specify the name of the alternate key. You can use alternate key in update and upsert operations.
For more information, see the Informatica PowerExchange for Microsoft Dynamics CRM 10.1.1 HotFix 1 User Guide for PowerCenter.
PowerExchange for SAP NetWeaver
Effective in version 10.1.1 HotFix 1, PowerExchange for SAP NetWeaver supports the SSTRING data type when you read data from SAP tables through ABAP. The SSTRING data type is represented as SSTR in PowerCenter.
For more information, see the Informatica PowerExchange for SAP NetWeaver 10.1.1 HotFix 1 User Guide.