Informatica PowerCenter

Informatica ETL (Extract, Transform and Loading) product, known as Informatica Power Center is a single unified data integration tool, which allows an organization to access the data from various types of source systems to transforming the data in to a homogeneous format and delivers the data through the enterprise at effective way.

Informatica PowerCenter includes following type of repositories:

1. Standalone Repository: A repository that functions individually and this is unrelated to any other repositories.
2. Global Repository: This is a centralized repository in a domain. This repository can contain shared objects across the repositories in a domain. The objects are shared through global shortcuts.
3. Local Repository: Local repository is within a domain and it’s not a global repository. Local repository can connect to a global repository using global shortcuts and can use objects in its shared folders.
4. Versioned Repository: This can either be local or global repository but it allows version control for the repository. A versioned repository can store multiple copies, or versions of an object. This feature allows efficiently developing, testing and deploying metadata in the production environment.

PowerCenter Server on Windows can connect to following databases:

• IBM DB2
• Informix
• Microsoft Access
• Microsoft Excel
• Microsoft SQL Server
• Oracle
• Sybase
• Teradata

PowerCenter Server on UNIX can connect to following databases:

• IBM DB2
• Informix
• Oracle
• Sybase
• Teradata