PowerCenter repository resides in a relational database. Repository database tables contain the instructions required to extract, transform, and load data. PowerCenter Client applications access the repository database tables through the Repository Service. The repository consists of database tables that store metadata. Metadata describes different types of objects, such as mappings or transformations, that we can create or modify using the Client tools.
Integration Service uses repository objects to extract, transform, and load data. The repository also stores administrative information such as user names, passwords, permissions, and privileges. we add metadata to the repository tables when you perform tasks in the PowerCenter Client application, such as creating users, analyzing sources, developing mappings or mapplets, or creating workflows. The Integration Service reads metadata created through the Client application when you run a workflow. It also creates metadata, such as start and finish times of a session or session status.
We can administer the repository using the Repository Manager client tool and we can also develop global and local repositories to share metadata.
Global repositoryGlobal 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 repositoriesLocal repository is any repository within the domain that is not the global repository. Use local repositories for development. From a local repository, we 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. we can also create copies of objects in non-shared folders.
