Tutorial corner


What is Informatica PowerCenter

Spread the love

What is Informatica PowerCenter ?

Informatica PowerCenter is one of the Enterprise Data Integration products developed by Informatica Corporation. Informatica PowerCenter is an ETL tool used for extracting data from the source, transforming and loading data in to the target.The PowerCenter server executes tasks based on work flow created by work flow managers. The work flows can be monitored using a work flow monitor. Jobs inside the program are designed in a mapping designer, which creates mapping between source and target. Mapping is a pictorial representation about flow of data from source to target. Transformations such as aggregation, filtering and joining are major examples of transformation.

Informatica PowerCenter

Informatica PowerCenter

Check here for ETL in Data warehouse

Component of Informatica PowerCenter

It comprises of three major applications:
1. Informatica PowerCenter Client Tools : These tools have been designed to enable a developer to:
– report metadata
– manage repository
– monitor sessions’ execution
– define mapping and session and work flow
2. Informatica PowerCenter Repository : The PowerCenter Repository stores information required to extract, transform, and load data in a relational database tables. It also stores administrative information such as permissions and privileges for users and groups that have access to the repository. PowerCenter applications access the PowerCenter repository through the Repository Service.

3. Informatica PowerCenter Server – Informatica server is the place where all the actions are executed. It reads the mapping rule from Repostory , then physically connects to sources and targets to fetch the data, apply all transformations and load the data into target systems.


Feature of Informatica PowerCenter:

Below are some of the main feature of Informatica which has made it popular among IT world

  • High performance:
  • Error Handling
  • Maintenance
  • Configuration Management
  • Adapt to Changes
  • Support for many data types
  • User Friendly

Informatica Versions History

Informatica Version Release Date
6.x September 2002
7.x March 2004
8.1.x May 2006
8.5.x October 2007
8.6.x June 2008
9.0.x December 2009
9.1 March 2011
9.5.x June 2012


Various Informatica Corporation products are:

  • Informatica Power Center
  • Informatica on demand
  • Informatica B2B Data Exchange
  • Informatica Data Quality
  • Informatica Data Explorer

Source :

  • www.Informatica.com
  • www.wikipedia.org

So in this article , we gave the introduction of Informatica Powercenter tool. In upcoming Informatica tutorial , we will go through  various transformation , mappings and informatica scenarios.

Updated: November 30, 2015 — 4:13 pm

The Author


Hello Friends , I am Kajal Mishra .I love to write article on latest technologies like Informatica , ETL , data warehouse , SQL-PL SQL
Copyright 2015 - Tutorial Corner Frontier Theme