PowerCenter - Repository

1 - About

A repository is a logic unit of a domain.

The repository contains the instructions required to:

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

3 - Management

3.1 - Administration

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

You administer the repository using :

PowerCenter - Administration Console snapshot:

3.2 - Database

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

CREATE USER POW_REP IDENTIFIED BY POW_REP 
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;
 
GRANT CONNECT, resource, CREATE VIEW TO POW_REP;

4 - Metadata

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.

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

5 - 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.

6 - PowerCenter version control

dit/powercenter/repository.txt ยท Last modified: 2018/02/16 09:12 by 108.162.221.16