Tuesday, February 8, 2011

PowerCenter 8 Overview



Informatica PowerCenter 8 provides an environment which allows us to load data into a centralized location, such as a data warehouse or operational data store (ODS). We can extract data from multiple sources, transform the data according to business logic, and load the transformed data into file and relational targets.


PowerCenter 8 also provides us the ability to view and analyze business information and browse and analyze metadata from disparate metadata repositories.


PowerCenter 8 Components


PowerCenter domain
PowerCenter repository
Administration Console
PowerCenter Client
Repository Service
Integration Service
Web Services Hub
Data Analyzer
Metadata Manager
PowerCenter Repository Reports