Informatica Power Center

                  Informatica PowerCenter provides an environment that allows you to load data into a centralized location, such as a datamart, data warehouse, or operational data store (ODS). 

                  You can extract data from multiple sources, transform the data according to business logic you build in the client application, and load the transformed data into file and relational targets. 

PowerCenter provides the following integrated components:

PowerCenter repository -

The PowerCenter repository is at the center of the PowerCenter suite. You create a set of metadata tables within the repository database that the PowerCenter applications and tools access. The PowerCenter Client and Server access the repository to save and retrieve metadata.

PowerCenter Repository Server -

The PowerCenter Repository Server manages connections to the repository from client applications. It inserts, updates, and fetches objects from the repository database tables. It also maintains object consistency.

PowerCenter Client - 

Use the PowerCenter Client to manage users, define sources and targets, build mappings and mapplets with the transformation logic, and create workflows to run the mapping logic. The PowerCenter Client has the following client applications: Repository Manager, Repository Server Administration Console, Designer, Workflow Manager, and Workflow Monitor.

PowerCenter Server -

The PowerCenter Server extracts the source data, performs the data transformation, and loads the transformed data into the targets.