Part III: Version 9.5.1 > New Features and Enhancements (9.5.1) > Version 9.5.1
  

Version 9.5.1

This section describes new features and enhancements in version 9.5.1.

Informatica Installer

This section describes new features and enhancements to the Informatica platform installer.

Pre-Installation (i9Pi) System Check Tool

If you run the Pre-Installation (i9Pi) System Check Tool, the values you enter during the system check appear as the default values in the Informatica installer during the services installation or upgrade.

Informatica Data Explorer

This section describes new features and enhancements to Informatica Data Explorer.

Data Domains

You can create data domains from the values and patterns in column profile results for use across the data systems or enterprise.
For more information, see Informatica Data Explorer 9.5.1 User Guide.

DDL Scripts from Profile Model

You can generate DDL scripts from the profile model. Supported databases are DB2, Oracle, and Microsoft SQL Server.
For more information, see Informatica Data Explorer 9.5.1 User Guide.

Enterprise Discovery

For more information, see Informatica Data Explorer 9.5.1 User Guide.

Export to Microsoft Excel

You can export data domain discovery results to Microsoft Excel from both Analyst and Developer tools. Export enterprise discovery results from the Developer tool to the client machine or a server location set in the Data Integration Service properties of Informatica Administrator.
For more information, see Informatica Data Explorer 9.5.1 User Guide.

Model Repository (MRX) Views

The MRX_PROFILERUNSTAT view provides information about the run-time statistics of a profile, profile model, or scorecard. The view provides information such as the object name, request type, start time and end time of the object, username, and the domain the user belongs to.
The MRX_PROFILE_SUMMARY view provides a summary of profile objects. The view provides information about the object name, type, and internal IDs.
For more information, see Informatica 9.5.1 Model Repository (MRX) Views.

Scorecards

For more information, see Informatica 9.5.1 Developer User Guide.

Informatica Data Quality

This section describes new features and enhancements to Informatica Data Quality.

Accelerators

The set of Informatica accelerators includes the Informatica Data Quality Accelerator for Spain. The accelerator contains rules, reference tables, demonstration mappings, and demonstration data objects that solve common data quality issues in Spanish data.
The core accelerator includes the following rule:
The Brazil accelerator includes the following rules:

Classifier Models

A classifier model is a type of reference data object that you can use to analyze input strings and determine the types of information they contain. You use a classifier model in a Classifier transformation.
Use a classifier model when input strings contain large amounts of data. For example, use a classifier model when you convert a series of documents or social media comments into a single data source.
You use the Developer tool to import classifier model files. The Model repository stores the classifier model object. The classifier model data is stored as a file on the Informatica services machine. The Content Management Service stores the path to the classifier model files that you import. Informatica uses the following directory path as the default location for classifier model files:
[Informatica_install_directory]/tomcat/bin/classifier
You can use the Content Management Service to update the location of the classifier model files on the Informatica services machine.
For more information, see Informatica 9.5.1 Data Quality User Guide.

Classifier Transformation

The Classifier transformation is a passive transformation that analyzes input fields and determines the type of information in each field. Use a Classifier transformation when each input field contains the contents of a document or a significant amount of text. A Classifier transformation uses a classifier model to analyze the input data.
For more information, see Informatica 9.5.1 Developer Transformation Guide.

Content Management Service

You can specify the temporary directory for the Content Management Service. The Content Management Service uses the directory to store reference table data during data import and export operations. You specify a directory on the Informatica services machine.
The default directory is [Informatica_install_directory]/Datafiles.
For more information, see Informatica 9.5.1 Administrator Guide.

Filter Projects

You can filter the list of projects that appear in the Object Explorer view before you connect to the Model repository. When you filter projects before you connect, you can decrease the amount of time that the Developer tool takes to connect to the repository.
For more information, see Informatica 9.5.1 Developer User Guide.

Informatica Data Director for Data Quality

You can use the following new features in Informatica Data Director for Data Quality:
For more information, see Informatica 9.5.1 Data Director for Data Quality User Guide.

Java Transformation

You can enable the Stateless advanced property for a Java transformation in the Developer tool. When you enable the Stateless advanced property, the Data Integration Service processes the input row without depending on the value of the previous row. The Stateless property is valid only in a Hive environment.
For more information, see Informatica 9.5.1 HotFix 3 Developer Transformation Guide.

Lookup Transformation

You can create a Lookup transformation in the Developer tool that looks up data in a reference table.
For more information, see Informatica 9.5.1 Developer Transformation Guide.

Match Transformation

You can view logs in the Developer tool that display progress data for a mapping that runs a Match transformation. The mapping adds a record to the log every time the Match transformation performs 100,000 record comparisons.
You can select the following options when you configure a Match transformation to sort duplicate records into clusters:
For more information, see Informatica 9.5.1 Developer Transformation Guide.

Model Repository (MRX) Views

The MRX_OBJECT_SUMMARY view provides a summary of Model repository objects. The view provides information about the project that the object belongs to, the object path, and user activity on the object.
For more information, see Informatica 9.5.1 Model Repository (MRX) Views.

Reference Tables

You can assign privileges to users and groups on reference table objects. Use the Security options in the Administrator tool to assign privileges.
For more information, see Informatica 9.5.1 Administrator Guide.

User-Defined Parameters

In the Developer tool, you can create a user-defined parameter in reusable Aggregator, Joiner, Rank, Reference Table Lookup, Relational Lookup, and Sorter transformations. You can assign the parameter to the cache file directory, temporary file directory, or connection fields in the transformation.
For more information, see Informatica 9.5.1 Developer User Guide.

Workflows

For more information, see Informatica 9.5.1 Developer Workflow Guide.

Informatica Data Services

This section describes new features and enhancements to Informatica Data Services.

Filter Projects

You can filter the list of projects that appear in the Object Explorer view before you connect to the Model repository. When you filter projects before you connect, you can decrease the amount of time that the Developer tool takes to connect to the repository.
For more information, see Informatica 9.5.1 Developer User Guide.

Find in Editor

In the Developer tool, you can search for attributes or virtual tables in the SQL data service editor. You can search for expressions, groups, ports, transformations, or virtual tables in the virtual table mapping editor. You can search for expressions, groups, ports, or transformations in the virtual stored procedure editor.
For more information, see Informatica 9.5.1 Developer User Guide.

Java Transformation

You can enable the Stateless advanced property for a Java transformation in the Developer tool. When you enable the Stateless advanced property, the Data Integration Service processes the input row without depending on the value of the previous row. The Stateless property is valid only in a Hive environment.
For more information, see Informatica 9.5.1 HotFix 3 Developer Transformation Guide.

Lookup Transformation

You can create a Lookup transformation in the Developer tool that looks up data in a reference table.
For more information, see Informatica 9.5.1 Developer Transformation Guide.

Mapping Specification

For more information, see Informatica 9.5.1 Data Integration Analyst User Guide.

Model Repository (MRX) Views

The MRX_OBJECT_SUMMARY view provides a summary of Model repository objects. The view provides information about the project that the object belongs to, the object path, and user activity on the object.
For more information, see Informatica 9.5.1 Model Repository (MRX) Views.

ODBC Driver Installation

You can install the Informatica data services ODBC drivers in silent mode on UNIX and Windows machines.
For more information, see Informatica Data Services 9.5.1 User Guide.

User-Defined Parameters

In the Developer tool, you can create a user-defined parameter in reusable Aggregator, Joiner, Rank, Reference Table Lookup, Relational Lookup, and Sorter transformations. You can assign the parameter to the cache file directory, temporary file directory, or connection fields in the transformation.
For more information, see Informatica 9.5.1 Developer User Guide.

Informatica Development Platform

This section describes new features and enhancements to Informatica Development Platform.

Design API

Version 9.5.1 includes the following enhancements for the Design API:
For more information, see Informatica Development Platform 9.5.1 IDP Developer Guide.

Informatica Domain

This section describes new features and enhancements to the Informatica domain.

Change Password Web Application

The Change Password web application allows you to change your password from Informatica Administrator and other Informatica client tools.

Command Line Programs

This section describes new commands and options for the Informatica command line programs.

infacmd cms Commands

The following table describes updated infacmd cms commands:
Command
Description
CreateService
Contains the following new options:
  • - -RepositoryUsername (-rsu). Required. User name to connect to the Model Repository Service.
  • - -RepositoryPassword (-rsp). Required. User name to connect to the Model Repository Service.
  • - -RepositorySecurityDomain (-rssd). Required if you use LDAP authentication. Name of the security domain that the user belongs to.
Update any script that uses the CreateService command with the new required options.
ResyncData
Contains new option -Type (-t). This option specifies the type of model file to synchronize. You can specify probabilistic model files or classifier model files.
UpdateServiceOptions
Enables new options:
  • - DataServiceOptions.RepositoryUsername. Specifies a username that the Content Management Service uses to connect to the Model Repository Service.
  • - DataServiceOptions.RepositoryPassword. Specifies a password that the Content Management Service uses to connect to the Model Repository Service.
  • - FileTransferOptions.TempLocation. Specifies a directory that the Content Management Service uses to stage data that it adds to a reference table.
UpdateServiceProcessOptions
Enables new options:
  • - GeneralOptions.JVMOptions. Specifies Java memory allocation options and Java virtual machine command line options.
  • - IdentityOptions.IdentityReferenceDataLocation. Specifies the location of identity population files.
  • - IdentityOptions.IdentityCacheDir. Specifies the location of the cache directory used in identity match analysis.
  • - IdentityOptions.IdentityIndexDir. Specifies the location of the index key directory used in identity match analysis.

infacmd dis Commands

The following table describes an updated infacmd dis command:
Command
Description
CreateService
Contains new option -httpProtocolType (-pt). This option specifies the security protocol that the Data Integration Service uses.

infacmd hts commands

infacmd hts commands manage the database tables that store Human task metadata.
The following table describes the infacmd hts commands:
Command
Description
CreateDB
Creates database tables that store Human task metadata.
DropBD
Drops database tables that store Human task metadata.
Exit
Stops all Human task operations, and passes the records associated with the task to the next stage in the workflow.

infacmd ipc Commands

The following table describes an updated command:
Command
Description
ExportToPC
The option -DsServiceName (-dsn) is removed. You do not need to specify a Data Integration Service when you run the command.
If you created scripts that use infacmd ipc ExportToPC, you must update the scripts.

infacmd rtm Commands

The following table describes an updated command:
Command
Description
Export
The option -DataIntegrationService (-ds) is removed. You do not need to specify a Data Integration Service when you run the command.
If you created scripts that use infacmd rtm Export, you must update the scripts.

infacmd wfs Commands

The following table describes a new infacmd wfs command:
Command
Description
ListWorkflows
Lists the workflows in an application.
For more information, see Informatica 9.5.1 Command Reference.

PowerCenter

This section describes new features and enhancements to PowerCenter.

Data Masking Transformation

You can configure advanced email address masking in the Data Masking transformation to create a realistic email address. You can generate an email address from a dictionary file or from the transformation output ports in the mapping. You can apply expressions to create an email address. You can also specify a domain dictionary to apply different domain names in the email address.
For more information, see the Informatica PowerCenter 9.5.1 Transformation Guide.

PowerCenter Big Data Edition

PowerCenter Big Data Edition consists of a set of components to process large and complex data sets that cannot be processed through standard database management tools.
PowerCenter Big Data Edition includes functionality from the following Informatica products: PowerCenter, Data Quality, Data Explorer, Data Transformation, Data Replication, PowerExchange for Hive, PowerExchange for HDFS, and social media adapters.
In addition to basic functionality associated with the Informatica products, you can perform the following functionality associated with big data:
Access big data sources
Access unstructured and semi-structured data, social media data, cloud applications data, and HDFS and Hive data. You can process data in a Informatica domain environment or a Hive environment.
Replicate data
Replicate big transactional data between heterogeneous databases and platforms.
High-performance processing within the Informatica domain
Distribute mapping, session, and workflow processing across nodes on a grid, enable partitioning to process partitions of data in parallel, and process data through highly available services. In a Informatica Domain or the native environment, the Integration Service runs a mapping, a profile, or a workflow. The Integration Service performs the data processing. The PowerCenter Integration Service runs the PowerCenter mappings, sessions, and workflows. The Data integration Service runs the Model repository mappings, profiles, and workflows.
High-performance processing in a Hive environment
Distribute mapping and profile processing across Hadoop cluster nodes in a Hive environment. In a Hive environment, you can configure a mapping, mappings in a workflow, or a profile to run on a Hadoop cluster from the Developer tool. You can import mappings from PowerCenter or you can develop mappings in the Developer tool. The Data Integration Service pushes the data processing to Hadoop. The Data Integration Service creates a Hive execution plan for the mapping or profile that consists of Hive queries. At run time, Hive generates MapReduce jobs for the Hive queries. You can monitor the MapReduce jobs in the Administrator tool and the Hadoop JobTracker
For more information, see PowerCenter Big Data Edition 9.5.1 User Guide.

Metadata Manager

This section describes new features and enhancements to Metadata Manager.

Data Lineage Performance Improvements

Metadata Manager generates data lineage diagrams much faster than it did in version 9.5.0.

Informatica Platform Resources

You can create and configure an Informatica Platform resource to extract metadata from an application deployed from Informatica Data Services or Informatica Data Quality. You can extract metadata from mappings and SQL data services.
For more information, see Informatica PowerCenter 9.5.1 Metadata Manager Administrator Guide.

Custom XConnect Created with a Load Template

For more information, see Informatica PowerCenter 9.5.1 Metadata Manager Custom Metadata Integration Guide.

Rule-Based Links

For more information, see Informatica PowerCenter 9.5.1 Metadata Manager Custom Metadata Integration Guide.

Informatica Business Glossary

Informatica Business Glossary Desktop
The Business Glossary Desktop is a desktop application that you can use to look up business terms and business term details in a business glossary. You can highlight a word in any application, such as an email application, and use hotkeys to look up the word in Business Glossary Desktop. The Business Glossary Desktop runs in the background and is accessible from the Windows system menu.
You can install the Business Glossary Desktop on a machine with the graphical installer. Or, an administrator can run the silent installer to install the Business Glossary Desktop on multiple machines.
For more information, see Informatica Business Glossary 9.5.1 Desktop Guide and Informatica Business Glossary Desktop 9.5.1 Installation and Configuration Guide.
Revise Published Business Terms
Revise a draft version of a published business term to change the term. When you revise a published term, Metadata Manager creates a revision copy of the term. After you make changes in the revision, you can follow the approval process to publish the term. Metadata Manager updates the original term, deletes the revision, and tracks changes in an audit trail.
For more information, see Informatica PowerCenter 9.5.1 Metadata Manager Business Glossary Guide.
Informatica Business Glossary API
You can use the Business Glossary API with any client that uses the HTTP protocol to request and retrieve business glossary data. The Business Glossary API allows developers to integrate lookups to the business glossary in other applications. The Business Glossary API is a REST API. The Business Glossary API uses the HTTP GET method to retrieve data from a business glossary.
For more information, see Informatica Business Glossary 1.0 API Guide.

Metadata Manager Application Properties

The following table describes new Metadata Manager application properties in the imm.properties file:
Property
Description
Catalog_Import_Batch_Size
The number of elements that Metadata Manager processes in one batch when you import metadata for a custom resource or a business glossary from an XML file. Increase this value if errors occur during XML import.
Glossary_Import_Export_Requires_Manage_Glossary_Privilege
Determines whether a user must have the Manage Glossary privilege to export or import a business glossary.
For more information, see Informatica PowerCenter 9.5.1 Metadata Manager Administrator Guide.

Performance Metrics

Metadata Manager writes lineage metrics such as number of links, number of resources, and graph build time to the following file:
<Informatica installation directory>\tomcat\temp\<service name>\logs\lineage_perf.csv

Resource Configuration Files

Resource configuration files contain new elements that provide information about the schedule that is attached to the resource and the enumerated links files that are associated with the resource.

Utilities to Migrate Resources and Resource Configuration Files

The following table describes new command line programs that allow you to migrate resources and resource configuration files:
Program
Description
rmu.bat
Migrates version 9.1.0 resources to version 9.5.1 resources. Also migrates deprecated resources.
rcfmu.bat
Migrates a version 9.1.0 resource configuration file to a version 9.5.1 resource configuration file.
For more information, see Informatica PowerCenter 9.5.1 Metadata Manager Administrator Guide.

PowerExchange Adapters

This section describes new features and enhancements to PowerExchange adapters.

Adapters for PowerCenter

PowerExchange for Greenplum
For more information, see Informatica PowerExchange for Greenplum 9.5.1 User Guide for PowerCenter.
PowerExchange for Microsoft Dynamics CRM
For more information, see Informatica PowerExchange for Microsoft Dynamics CRM 9.5.1 User Guide for PowerCenter.
PowerExchange for SAP NetWeaver BI
For more information, see Informatica PowerExchange for SAP NetWeaver 9.5.1 User Guide for PowerCenter.
PowerExchange for Teradata Parallel Transporter API
You can authenticate a user using either Native or LDAP authentication.
For more information, see Informatica PowerExchange for Teradata Parallel Transporter API 9.5.1 User Guide for PowerCenter.
PowerExchange for Ultra Messaging
For more information, see Informatica PowerExchange for Ultra Messaging 9.5.1 User Guide for PowerCenter.

Adapters for Informatica

PowerExchange for DataSift
For more information, see Informatica PowerExchange for DataSift 9.5.1 User Guide.
PowerExchange for Facebook
For more information, see Informatica PowerExchange for Facebook 9.5.1 User Guide.
PowerExchange for HDFS
For more information, see Informatica PowerExchange for HDFS 9.5.1 User Guide.
PowerExchange for Hive
For more information, see Informatica PowerExchange for Hive 9.5.1 User Guide.
PowerExchange for LinkedIn
For more information, see Informatica PowerExchange for LinkedIn 9.5.1 User Guide.
PowerExchange for Teradata Parallel Transporter API
For more information, see Informatica PowerExchange for Teradata Parallel Transporter API 9.5.1 User Guide.
PowerExchange for Twitter
For more information, see Informatica PowerExchange for Twitter 9.5.1 User Guide.
PowerExchange for Web Content-Kapow Katalyst
You can use Kapow Katalyst through an HTTP proxy server to access web content.
For more information, see Informatica PowerExchange for Web Content-Kapow Katalyst 9.5.1 User Guide.

Documentation

This section describes new features and enhancements to the documentation.

Business Glossary Desktop

Business Glossary Desktop includes the following new guides:
Informatica Business Glossary Desktop Guide
Contains information about using Business Glossary Desktop to look up business terms and business term details in a business glossary.
Informatica Business Glossary Desktop Installation and Configuration Guide
Contains information about installing and configuring Business Glossary Desktop.
Informatica Business Glossary API Guide
Contains information about the Business Glossary API, which developers can use to integrate lookups to the business glossary in other applications.