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.
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
- Configuration Management
- Adapt to Changes
- Support for many data types
- User Friendly
Informatica Versions History
|Informatica Version||Release Date|
Various Informatica Corporation products are:
- Informatica Power Center
- Informatica on demand
- Informatica B2B Data Exchange
- Informatica Data Quality
- Informatica Data Explorer
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.