Informatica version 9.6 latest features

Informatica version 9.6 added many new features in various categories. The below post tells some of the important enhancements in the new version. You can read informatica version 9.5 enhancements here.

Informatica Analyst

The following work spaces added.

  • Start- Access other workspaces that you have the license to access through access panels on this workspace. If you have the license to perform exception management, your tasks appear in this workspace.
  • Glossary- Define and describe business concepts that are important to your organization.
  • Discovery- Analyze the quality of data and metadata in source systems.
  • Design- Design business logic that helps analysts and developers collaborate.
  • Scorecards- Open, edit, and run scorecards that you created from profile results.
  • Library- Search for assets in the Model repository. You can also view metadata in the Library workspace.
  • Exceptions- View and manage exception record data for a task. View duplicate record clusters or exception records depending on the type of task you are working on. View an audit trail of the changes you make to records in a task.
  • Connections- Create and manage connections to import relational data objects, preview data, run a profile, and run mapping specifications.
  • Data Domains – Create, manage, and remove data domains and data domain groups.
  • Job Status -Monitor the status of Analyst tool jobs such as data preview for all objects and drilldown operations on profiles.
  • Projects- Create and manage folders and projects and assign permissions on projects.

Informatica Data Services:

Java Transformation – In a Java transformation, you can configure an input port as a partition key, a sort key, and assign a sort direction. The partition key and sort key are valid when you process the transformation in a mapping that runs in a Hive environment.

Lookup Transformation – If you cache the lookup source for a Lookup transformation, you can use a dynamic cache to update the lookup cache based on changes to the target. The Data Integration Service updates the cache before it passes each row to the target.

Normalizer Transformation – The Normalizer transformation is an active transformation that transforms one source row into multiple output rows. When a Normalizer transformation receives a row that contains repeated fields, it generates an output row for each instance of the repeated data. Use the Normalizer transformation when you want to organize repeated data from a relational or flat file source before you load the data to a target.

Automatic Workflow Recovery – You can configure automatic recovery of aborted workflow instances due to an unexpected shutdown of the Data Integration Service process. When you configure automatic recovery, the Data Integration Service process recovers aborted workflow instances due to a service process shutdown when the service process restarts.

Performance Improvement – In the Developer tool you can enable a mapping to perform the following optimizations:

  • Push a Union transformation to a relational data object.
  • Push Filter, Expression, Union, Sorter, and Aggregator transformations to a Hive relational object.

Rule Builder – Rule Builder is an Informatica Analyst feature that converts business rule requirements to transformation logic. You save the business rule requirements in a rule specification. When you compile the rule specification, the Analyst tool creates transformations that can analyze the business data according to the requirements that you defined. The Analyst tool saves the transformations to one or more mapplets in the Model repository.

Metadata Manager – Security: Secure connection to all RDBMSs

Power exchange Adapters – This version provides many adapters to connect HBase, DataSift, Facebook, HDFS, HIVE, Linkedin, Salesforce,SAP Netweaver, Twitter

Informatica powercenter adapters – GreePlum, Hadoop,MS Dynamic CRM, SAP Netweaver, Siebel, Teradata, Web Services

Power Center – Push down optimization for  SAPHANA, Teradata, GreenPlum

Informatica Data Quality – You can configure automatic recovery of aborted workflow instances due to an unexpected shutdown of the Data Integration Service process. When you configure automatic recovery, the Data Integration Service process recovers aborted workflow instances due to a service process shutdown when the service process restarts.

Read more…

  1. Informatica interview questions-part-1
  2. Informatica differences for V8x and V9x
Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.