Version 9.5.1 HotFix 1
This section describes new features and enhancements in version 9.5.1 HotFix 1.
Informatica Data Explorer
This section describes the new features and enhancements to Informatica Data Explorer.
Look Up Business Terms
Look up the meaning of a Model repository object name as a business term in the Business Glossary Desktop to understand its business requirement and current implementation.
You can select an object in the Analyst tool, and use hotkeys to look up the name of the object in the Business Glossary Desktop. You can look up names of objects in Analyst tool views such as the Properties view or Navigator, or names of columns and profiles.
You can select an object in the Developer tool, and use hotkeys or the Search menu to look up the name of the object in the Business Glossary Desktop. You can look up names of objects in Developer tool views such as the Object Explorer view or editor, or names of columns and profiles in the editor.
For more information, see Informatica Data Explorer 9.5.1 HotFix 1 User Guide.
Scorecard Lineage
View a scorecard lineage diagram for a scorecard metric or metric group in Informatica Analyst. Use scorecard lineage to analyze the root cause of unacceptable score variance for a metric or metric group and understand the data flow. To view the scorecard lineage diagram, export scorecards to an XML file from Informatica Developer. Use the exported XML file to create and load a resource file in Metadata Manager. The name of the resource file that you create and load in Metadata Manager must use the following naming convention: <MRS name>_<project name>. You can then launch scorecard lineage from Informatica Analyst.
For more information, see Informatica Data Explorer 9.5.1 HotFix 1 User Guide.
Informatica Data Quality
This section describes new features and enhancements to Informatica Data Quality.
Accelerators
Informatica country accelerators include rules that calculate geographic coordinates for an address location.
The Core Accelerator includes rules that perform the following types of analysis:
- •Calculate the distance between two geographic coordinates.
- •Determine if a geographic coordinate falls inside or outside a set of coordinates that form a polygon shape.
For more information, see Informatica Data Quality 9.5.1 HotFix 1 Accelerator Guide.
Address Validator Transformation
The Address Validator transformation adds the following types of validation data and enrichment data to address records:
- •Validation status indicators for New Zealand addresses, including the SendRight validation standard that New Zealand Post defines for certified addresses.
- •Validation for address elements to delivery point level in New Zealand addresses.
- •Locality ISO code values for Australian addresses.
- •Extended validation status indicators for data elements in all addresses.
You can specify the maximum number of address suggestions that the Address Validator transformation returns in suggestion list mode.
For more information, see Informatica 9.5.1 HotFix 1 Address Validator Port Reference.
Classifier Models
You can perform the following classifier model operations in the Developer tool:
- •Create a classifier model.
- •Add label values and data values to a classifier model.
- •Assign labels to data rows
- •Edit label names.
- •Filter the data rows that display in a classifier model.
- •Search data rows for data values.
- •Copy and paste classifier models between content sets in the Model repository.
For more information, see Informatica Data Quality 9.5.1 HotFix 1 User Guide.
Classifier Transformation
You can configure a Classifier transformation to generate a classifier score for each row of input data.
A classifier score represents the degree of similarity between the input data and the classifier model that the transformation uses to analyze the input data.
A high percentage score indicates a high degree of similarity.
For more information, see Informatica 9.5.1 Developer Transformation Guide.
Look Up Business Terms from Informatica Developer
Look up the meaning of a Model repository object name as a business term in the Business Glossary Desktop to understand its business requirement and current implementation.
You can select an object in the Developer tool and use hotkeys or the Search menu to look up the name of the object in the Business Glossary Desktop. You can look up the names of objects in the Object Explorer such as the names of reference data objects. You can look up the names of elements in the mapping editor such as transformation port names.
For more information, see Informatica 9.5.1 HotFix 1 Developer User Guide and Informatica Data Quality 9.5.1 HotFix 1 Analyst User Guide.
Pushdown Optimization Enhancements
You can push transformation logic for an Aggregator transformation and a Sorter transformation to a relational source database.
For more information see the Informatica Developer 9.5.1 HotFix 1 User Guide.
Reference Tables
You can perform the following operations on reference tables:
- •You can edit unmanaged reference table data in the Developer tool and Analyst tool. You can edit unmanaged reference table metadata in the Analyst Tool.
- •You can remove unused tables from the reference data warehouse. When you delete a reference table object from the Model repository, the associated tables in the reference data warehouse are no longer used by Informatica.
Run the infacmd cms Purge command to remove all unused tables from the reference data database. Or, use the Content Management Service options in the Administrator tool.
For more information, see Informatica 9.5.1 HotFix 1 Command Reference and Informatica 9.5.1 HotFix 1 Administrator Guide.
Workflows
If you enable a workflow for recovery, you can recover a workflow instance from the point of interruption. You interrupt a workflow when you abort or cancel the workflow instance. A Data Integration Service interrupts a workflow when the service shuts down unexpectedly.
Use the Developer tool to enable a workflow for recovery. When you enable a workflow for recovery, you must define a recovery strategy for each Command, Mapping, and Notification task in the workflow. A task recovery strategy defines how the Data Integration Service completes an interrupted task during a workflow recovery run. A Command, Mapping, and Notification task can have a restart or a skip recovery strategy. A Human task always has a restart strategy.
Use the Monitoring tab of the Administrator tool or use the infacmd wfs command line programs to recover aborted or canceled workflow instances that you enabled for recovery.
For more information, see Informatica 9.5.1 HotFix 1 Developer Workflow Guide.
Informatica Data Services
This section describes new features and enhancements to Informatica Data Services.
Look Up Business Terms
In the Analyst tool or Developer tool, you can look up the meaning of a Model repository object name as a business term in the Business Glossary Desktop to understand its business requirement and current implementation.
You can select an object in the Analyst tool, and use hotkeys to look up the name of the object in the Business Glossary Desktop. You can look up names of objects in Analyst tool views such as the Properties view or Navigator, or names of columns, profiles, and mapping specifications and transformation objects.
You can select an object in the Developer tool, and use hotkeys or the Search menu to look up the name of the object in the Business Glossary Desktop. You can look up names of objects in Developer tool views such as the Object Explorer view or editor, or names of columns, profiles, and mapping ports in the editor.
For more information see the Informatica Data Integration Analyst 9.5.1 User Guide and the Informatica Developer 9.5.1 User Guide.
Mapping Specification Enhancements
In the Analyst tool, you can duplicate a target column or move a target column up or down.
You can search for a data object when you add a source or a lookup to a mapping specification. You can also search for a reusable rule when you apply a rule to a mapping specification.
Pushdown Optimization Enhancements
You can push transformation logic for an Aggregator transformation and a Sorter transformation to a relational source database.
For more information see the Informatica Developer 9.5.1 HotFix 1 User Guide.
Informatica Data Transformation
This section describes new features and enhancements to Informatica Data Transformation.
Data Transformation Libraries
Data Transformation libraries contain predefined transformation components used with the a range of industry messaging standards. The Data Processor transformation uses a Library object to transform an industry messaging type input into a different format, such as an XML output document.
The Library object contains a large number of objects and components, such as parsers, serializers, and XML schemas, preset to transform the industry standard input and specific application messages into XML or other output. Some libraries contain additional objects for message validation, acknowledgments, and diagnostic displays. You can also customize the properties and validation settings of the Library object.
For more information, see Data Transformation 9.5.1 HotFix 1 User Guide.
Data Transformation with JSON Input
A Data Processor transformation can contain JSON input with an .xsd schema file that defines JSON input file hierarchies.
You create a project with a JSON input schema in Data Transformation. The JSON schema is converted into an .xsd file that Data Transformation uses to transform JSON input. You can import the project into your repository and use the .xsd in Data Processor transformations to support JSON input with the same hierarchy.
For more information, see Data Transformation 9.5.1 HotFix 1 Studio User Guide.
Informatica Domain
This section describes new features and enhancements to the Informatica domain.
Recover Workflows
When you monitor workflows, you can recover aborted or canceled workflow instances that are enabled for recovery. A workflow instance has an aborted state if a task with a restart recovery strategy encounters a recoverable error, if you abort the workflow instance, or if the Data Integration Service process shuts down unexpectedly. A workflow instance has a canceled state if you cancel the workflow instance.
When you recover a workflow instance, the Data Integration Service restarts or skips the interrupted task based on the task recovery strategy. The service continues processing the subsequent workflow objects.
When you upgrade a domain that contains aborted or canceled workflow instances, you cannot recover the upgraded workflow instances because the deployed workflow definitions are not enabled for recovery.
For more information, see Informatica 9.5.1 HotFix 1 Administrator Guide.
Command Line Programs
This section describes new and changed commands and options for the Informatica command line programs.
infacmd cms Commands
The following table describes a new infacmd cms command:
Command | Description |
|---|
Purge | Deletes data that is not used by a reference table object from the reference data database. |
infacmd oie Commands
The following table describes a new infacmd oie command:
Command | Description |
|---|
exportResources | Exports scorecard objects and lineage information in a project or folder to an XML file that you use in Metadata Manager. |
infacmd pwx Commands
The following table describes a deprecated infacmd pwx command:
Command | Description |
|---|
DisplayCheckpointsLogger | No longer displays checkpoint information for a PowerExchange Logger Service because the PowerExchange Logger no longer uses checkpoint files. If you enter this command, the PowerExchange Logger reports that the command is not valid. |
infacmd wfs Commands
The following table describes new infacmd wfs commands:
Command | Description |
|---|
abortWorkflow | Aborts a running workflow instance. |
cancelWorkflow | Cancels a running workflow instance. |
listActiveWorkflowInstances | Lists active workflow instances. An active workflow instance is an instance on which an action can be performed. |
recoverWorkflow | Recovers an interrupted workflow instance. |
pmrep Commands
The following table describes an updated pmrep command:
Command | Description |
|---|
RollbackDeployment | Contains the following new options: - - -repositoryname (-r). Optional. Name of the source repository from where you deploy the deployment group.
- - -nth_latest_version_of_deployment_group (-v). Optional. Version of the deployment group you want to roll back.
|
For more information, see Informatica 9.5.1 HotFix 1 Command Reference.
PowerCenter Big Data Edition
This section describes new features and enhancements to PowerCenter Big Data Edition.
Workflows
If you enable a workflow for recovery, you can recover a workflow instance from the point of interruption. A running workflow instance can be interrupted when an error occurs, when you abort or cancel the workflow instance, or when a Data Integration Service process shuts down unexpectedly.
Use the Developer tool to enable a workflow for recovery. When you enable a workflow for recovery, you must define a recovery strategy for each Command, Mapping, and Notification task in the workflow. A task recovery strategy defines how the Data Integration Service completes an interrupted task during a workflow recovery run. A task can have a restart or a skip recovery strategy.
Use the Monitoring tab of the Administrator tool or use the infacmd wfs command line programs to recover aborted or canceled workflow instances that are enabled for recovery.
For more information, see Informatica 9.5.1 HotFix 1 Developer Workflow Guide.
Mappings in a Hive Environment
Effective in 9.5.1 HotFix 1, you can run mappings in a Hive environment with Cloudera 4.1.2 distribution.
For more information, see PowerCenter Big Data Edition 9.5.1 HotFix 1 User Guide.
Metadata Manager
This section describes new features and enhancements to Metadata Manager.
Linking Rule Definitions between Models
You can create linking rule definitions for pairs of models. Create linking rule definitions for a pair of models so that you can apply the same linking rules to different resources associated with the models. For example, you develop a custom model, "CustomETL," and you need to link objects in CustomETL resources with objects in Oracle resources. You can create a linking rule definition between the CustomETL model and the Oracle model and then instantiate the rule definition for each pair of resources of the two models.
For more information, see Informatica PowerCenter 9.5.1 HotFix 1 Metadata Manager Custom Metadata Integration Guide.
Lineage for Scorecards
You can view lineage for scorecards. Create an Informatica Platform resource from a resource file exported from the Developer tool, and then view lineage for objects in the Informatica Platform resource.
For more information, see Informatica PowerCenter 9.5.1 HotFix 1 Metadata Manager Administrator Guide.
Lineage for Data Quality Transformations
You can view port-level lineage for Data Quality transformations. Create an Informatica Platform resource, and run data lineage on the resource.
For more information, see Informatica PowerCenter 9.5.1 HotFix 1 Metadata Manager Administrator Guide.
Resource Configuration Files
You can export resource properties to a resource configuration file on the Load tab. When you export the resource configuration, you can optionally include rule sets. You can also import resource properties from a resource configuration file on the Load tab.
For more information, see Informatica PowerCenter 9.5.1 HotFix 1 Metadata Manager Custom Metadata Integration Guide.
Keyword Search
As you type a search string in the Search list, Metadata Manager displays completed search strings that you can select.
PowerExchange Adapters
This section describes new features and enhancements to PowerExchange adapters.
Adapters for PowerCenter
- PowerExchange for Hadoop for PowerCenter
Effective in 9.5.1 HotFix 1, PowerExchange for Hadoop supports Cloudera 4.1.2 and HortonWorks 1.1 to access Hadoop sources and targets.
For more information, see Informatica PowerExchange for Hadoop 9.5.1 HotFix 1 User Guide for PowerCenter.
- PowerExchange for Salesforce for PowerCenter
Effective in 9.5.1 HotFix 1, you can add a prefix to the names of PowerExchange for Salesforce success log files and failure log files.
For more information, see the Informatica PowerExchange for Salesforce 9.5.1 HotFix 1 User Guide for PowerCenter.
- PowerExchange for Teradata Parallel Transporter API
- Effective in 9.5.1 HotFix 1, you can configure the following session properties for a Teradata PT API target:
Property | Description |
|---|
Insert | Teradata PT API creates a DML group to insert rows. |
Update | Teradata PT API creates a DML group to update rows. |
Delete | Teradata PT API creates a DML group to delete rows. |
When you upgrade to PowerExchange for Teradata Parallel Transporter API version 9.5.1 HotFix 1, you must register the TeradataPT.xml file with the PowerCenter repository to use the new features introduced in version 9.5.1 HotFix 1.
For more information, see the Informatica PowerExchange for Teradata Parallel Transporter API 9.5.1 HotFix 1 User Guide for PowerCenter.
Adapters for Informatica
- PowerExchange for Salesforce
- - You can use PowerExchange for Salesforce to read data from Salesforce sources.
- - You can use the Developer tool to import a Salesforce data object and create a data object read operation. You can import both standard and custom Salesforce objects and read related objects.
- - You can define data object read operation properties that determine how data is read from Salesforce sources.
- - The data object read operation properties you can set include properties for changed data capture, bulk API, row limit, custom SOQL, sorted ports, and page size.
- - You can use the data object read operation as a source in the mappings.
- - You can run mappings developed in the Developer tool.
- - You can access Salesforce through an HTTP proxy server.
For more information, see the Informatica PowerExchange for Salesforce 9.5.1 HotFix 1 User Guide.