Version 9.5.1 HotFix 2
This section describes new features and enhancements in version 9.5.1 HotFix 2.
Informatica Data Quality
This section describes new features and enhancements to Informatica Data Quality.
Address Validator Transformation
The transformation delivers the following enhancements in Canadian address validation:
- •You can change the language that the transformation uses to write a street descriptor or a Province name. You can change the language to English or to French. For example you can change "Street" to "Rue."
- •You can return the thirteen-character locality code that identifies a locality.
- •You can return the rural route identifier for an address.
The transformation delivers the following enhancements in French address validation:
- •You can verify and correct addresses to the certification standards of the French National Address Management Service (SNA). SNA certifies the address validation software to verify and correct French address to street level.
- •You can return the CEDEXA identifier for a mail center or postal facility.
The transformation delivers the following enhancements in Serbian address validation:
- •You can add the PAK postal address code to a Serbian address. The six-digit PAK code identifies the street that contains the address mailbox.
The transformation delivers the following enhancements in United Kingdom address validation:
- •You can add Unique Delivery Point Reference Number (UDPRN) data to a United Kingdom address. The UDPRN is an eight-digit code that uniquely identifies a United Kingdom address.
The transformation extends the range of status codes that the following ports can return for an address:
- •Address Resolution Code. The port returns an alphanumeric code that describes the status of non-valid address elements in an address.
- •Extended Element Status. The port returns an alphanumeric code that supplements the status data on the Element Input Status port and Element Result Status port.
For more information, see Informatica 9.5.1 HotFix 2 Address Validator Port Reference and Informatica 9.5.1 HotFix 2 Developer Transformation Guide.
Data Masking
The Data Masking transformation can mask integer and bigint data for phone number masking.
For more information, see Informatica 9.5.1 HotFix 2 Developer Transformation Guide.
Import From PowerCenter
When you import PowerCenter objects in the Developer tool, you can assign a single connection in the Model repository to multiple PowerCenter objects at the same time. You can assign a single connection to all sources, all targets, all Lookup transformations, or all objects that do not have an assigned connection. Or, you can assign a single connection to all objects with names that match a specified name pattern.
For more information, see Informatica 9.5.1 HotFix 2 Developer User Guide.
Informatica Data Services
This section describes new features and enhancements to Informatica Data Services.
Data Masking
The Data Masking transformation can mask integer and bigint data for phone number masking.
For more information, see Informatica 9.5.1 HotFix 2 Developer Transformation Guide.
Import From PowerCenter
When you import PowerCenter objects in the Developer tool, you can assign a single connection in the Model repository to multiple PowerCenter objects at the same time. You can assign a single connection to all sources, all targets, all Lookup transformations, or all objects that do not have an assigned connection. Or, you can assign a single connection to all objects with names that match a specified name pattern.
For more information, see Informatica 9.5.1 HotFix 2 Developer User Guide.
Informatica Domain
This section describes new features and enhancements to Informatica Domain.
Informatica Administrator
You can search the Informatica Knowledge Base from the Administrator tool. You can also, click an error message code to view the search results for the error in the Informatica Knowledge Base.
For more information, see Informatica 9.5.1 HotFix 2 Administrator Guide.
Connectivity
You can create a connection to an Oracle database with the Oracle Advanced Security (OAS) option enabled using the DataDirect JDBC driver.
For more information, see Informatica 9.5.1 HotFix 2 Installation Guide.
PowerCenter
This section describes new features and enhancements to PowerCenter.
Data Masking
The Data Masking transformation can mask integer and bigint data for phone number masking.
For more information, see Informatica PowerCenter 9.5.1 HotFix 2 Transformation Guide.
PowerCenter Big Data Edition
This section describes new features and enhancements to PowerCenter Big Data Edition.
Mappings in a Hive Environment
You can run mappings in a Hive environment with MapR 2.1.2 and Hortonworks 1.1 distribution.
For more information, see PowerCenter Big Data Edition 9.5.1 HotFix 2 User Guide.
Metadata Manager
This section describes new features and enhancements to Metadata Manager.
Metadata Extraction Performance Improvements
To increase metadata extraction performance for Business Objects, Cognos, and Oracle Business Intelligence Enterprise Edition (OBIEE) resources, the Metadata Manager Agent can use multiple worker threads for metadata extraction. The Metadata Manager Agent calculates the optimal number of threads based on the JVM architecture and number of available CPU cores on the machine that runs the Metadata Manager Agent. You can also configure the number of threads manually.
For more information, see Informatica PowerCenter 9.5.1 HotFix 2 Metadata Manager Administrator Guide.
Resource Types
You can create the following resource types:
- •Business Objects 14.0 SP6
- •Cognos 10.2. Previously, you could create Cognos resources up to version 10.1.
- •ERwin 9.1 (File)
- •ERwin 9.1 (Single Model from mart)
For more information, see Informatica PowerCenter 9.5.1 HotFix 2 Metadata Manager Administrator Guide.
Oracle ASO Support
You can create an Oracle resource when the Oracle database uses the Oracle Advanced Security Option (ASO). You can also create a Metadata Manager repository on an Oracle database that uses the Advanced Security Option.
For more information, see Informatica PowerCenter 9.5.1 HotFix 2 Metadata Manager Administrator Guide.
PowerExchange Adapters
This section describes new features and enhancements to PowerExchange adapters.
Adapters for PowerCenter
- PowerExchange for Hadoop for PowerCenter
PowerExchange for Hadoop supports MapR 2.1.2 and EMC Greenplum PivotalHD 2.0.1 to access Hadoop sources and targets.
For more information, see Informatica PowerExchange for Hadoop 9.5.1 HotFix 2 User Guide for PowerCenter.
- PowerExchange for Salesforce for PowerCenter
You can configure a CDC flush interval offset to capture real-time data that is submitted within the CDC time limit but not committed by Salesforce within the time limit.
For more information, see Informatica PowerExchange for Salesforce 9.5.1.2.1 User Guide for PowerCenter.
- PowerExchange for Salesforce for PowerCenter
- - In Salesforce Bulk API sessions, the PowerCenter Integration Service can permanently delete rows from the target machine.
- - You can configure the directory for the Bulk API error log file.
- - You can configure the polling interval for a Bulk API session.
For more information, see Informatica PowerExchange for Salesforce 9.5.1 HotFix 2 User Guide for PowerCenter.
- PowerExchange for Teradata Parallel Transporter API
You can specify how Teradata PT API marks error rows when it attempts to update or delete multiple rows in the target table. You can mark extra rows with any of the following values:
- - None
- - For update
- - For delete
- - Both
For more information, see Informatica PowerExchange for Teradata Parallel Transporter API 9.5.1 HotFix 2 User Guide for PowerCenter.
Adapters for Informatica
- PowerExchange for DataSift
Use the PowerExchange for Social Media 9.5.1 HotFix 2 installer to install PowerExchange for DataSift.
For more information, see Informatica PowerExchange for DataSift 9.5.1 Hot Fix 2 User Guide.
- PowerExchange for Facebook
- - PowerExchange for Facebook uses the Facebook API to control the number of rows that you request when a mapping runs.
- - Use the PowerExchange for Social Media 9.5.1 HotFix 2 installer to install PowerExchange for Facebook.
For more information, see Informatica PowerExchange for Facebook 9.5.1 Hot Fix 2 User Guide.
- PowerExchange for LinkedIn
- - PowerExchange for LinkedIn uses the LinkedIn API to control the number of rows that you request when a mapping runs.
- - You can specify the profile query parameter in new formats.
For more information, see Informatica PowerExchange for LinkedIn 9.5.1 Hot Fix 2 User Guide.
- PowerExchange for Twitter
PowerExchange for Twitter uses the Twitter API to control the number of rows that you request when a mapping runs.
For more information, see Informatica PowerExchange for Twitter 9.5.1 Hot Fix 2 User Guide.
- PowerExchange for Web Content-Kapow Katalyst
Use the PowerExchange for Social Media 9.5.1 HotFix 2 installer to install PowerExchange for Web Content-Kapow Katalyst.
For more information, see Informatica PowerExchange for Web Content-Kapow Katalyst 9.5.1 Hot Fix 2 User Guide.