PowerCenter - Repository

Card Puncher Data Processing


A repository is a logic unit of a domain.

Powercenter Repository Adminconsole

The repository contains the instructions required to:

  • extract, transform, and load data
  • and store administrative information such as :
    • permissions,
    • and privileges.



PowerCenter applications access the repository through the PowerCenter - Repository Service (Process).

You administer the repository using :

PowerCenter - Administration Console snapshot:

Powercenter Repository Adminconsole


The PowerCenter repository resides in a relational database. For Oracle, when you create the database user, you create it with the following instruction :

DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;

GRANT connect, resource, create view TO POW_REP;

Powercenter Repository Database Property


You can view repository metadata in the PowerCenter - Repository Manager. The Informatica Metadata Exchange (MX) provides a set of relational views that allow easy SQL access to the PowerCenter metadata repository.

The views are created during the installation of the upgrade of the repository with the help of mxbld file query (for instance for oracle oramxbld.sql). You find then this view in the PowerCenter Repository schema and they begin with REP.

Powercenter Mx Views

More informations on the content of the views in the repository documentation (chapter 15. Using Metadata Exchange View).

  • A widget is a component of a mapping
  • A task is a component of a workflow

Global and local repositories

You can develop global and local repositories to share metadata:

  • Global repository. The global repository is the hub of the repository domain. Use the global repository to store common objects that multiple developers can use through shortcuts. These objects may include operational or Application source definitions, reusable transformations, mapplets, and mappings.
  • Local repositories. A local repository is any repository within the domain that is not the global repository. Use local repositories for development. From a local repository, you can create shortcuts to objects in shared folders in the global repository. These objects include source definitions, common dimensions and lookups, and enterprise standard transformations. You can also create copies of objects in non-shared folders.

PowerCenter version control

See Powercenter - Version Control

Discover More
Powercenter Component
PowerCenter - Architecture/Components

Architecture for 8.x version of Informatica PowerCenter. PowerCenter provides an environment that allows you to load data into a centralized location, such as a data warehouse or operational data store...
Card Puncher Data Processing
PowerCenter - Changes in Informatica Terminology (Term used)

in 7.1.x versions of Informatica PowerCenter in 8.x version of Informatica PowerCenter Informatica Repository Informatica Repository The Informatica Repository is managed by the Repository Service....
Card Puncher Data Processing
PowerCenter - Client

The PowerCenter Client consists of the following applications that you use to manage the repository, design mappings, mapplets, and create sessions to load the data: . Use the Designer to create mappings...
Edlivery Oracle Bi
PowerCenter - Installation and Configuration (8.1.1 for Windows 32Bit)

This article talk the installation of the data integration tool PowerCenter from Informatica. The files for the software Informatica PowerCenter and PowerConnect Adapters 8.1.1 SP5 are available...
Edlivery Oracle Bi
PowerCenter - Installation and Configuration (8.6.1 for Windows 32Bit)

This article talk the installation of PowerCenter from Informatica on: Windows 32 bit Oracle Database Oracle Business Intelligence Application version installation The oracle database...
Powercenter 901 Installation License And Directory
PowerCenter - Installation and Configuration (9.0.1 for OEL Linux 64Bit)

Text format: ... Installation Type: Install (and not upgrade) Pre-requisites: Next License and Directory. (Transfer the license file from the client zip file) Pre-Installation Summary: Install...
Powercenter Integration Service
PowerCenter - Integration Service

The PowerCenter Integration Service is an application service that runs workflows and sessions for the PowerCenter Client. The Integration Service reads workflow information from the repository. The...
Powercenter Pre Session Variable Assignment
PowerCenter - Mapping (Parameter|Variable)

When you use a mapping parameter or variable in a mapping, first you declare the mapping parameter or variable for use in each mapplet or mapping. Then, you define a value for the mapping parameter or...
Powercenter Metadata Manager Architect
PowerCenter - Metadata Manager

PowerCenter Metadata Manager is a metadata management tool that you can use to browse and analyze metadata from disparate metadata repositories. Metadata Manager helps you understand and manage how information...
Powercenter Repository Service
PowerCenter - Repository Service (Process)

The Repository Service manages connections to the repository from client applications. The Repository Service is a separate, multi-threaded process that retrieves, inserts, and updates metadata in the...

Share this page:
Follow us:
Task Runner