Informatica PowerCenter Repository Manager is used for creating new domains and used to administer repositories. In this Informatica tutorial, you will learn about Informatica PowerCenter Repository Manager task that can be performed.

Informatica PowerCenter Repository Manager

Informatica PowerCenter Repository Manager is a GUI based Administrative client component, which allows user  to create new domains and used to organize the meta data stored in the Repository. Folders in Repository are used to organize the meta data. Informatica user can navigate through multiple folders and repositories and can perform the following tasks :

  • Manage user and group permissions : Assign and revoke folder and global object permissions.
  • Perform folder functions : Can Create, edit, copy, and delete folders. Every Work that performed in Informatica PowerCenter Designer and Workflow Manager is stored in folders. If you want to share metadata, you can configure a folder to be shared.
  • View metadata :  Analyze sources, targets, mappings, and shortcut dependencies, search by keyword, and view the properties of PowerCenter repository objects.

Informatica PowerCenter Repository Manager screen consists of 4 windows they are

  1. Status Bar.
  2. Navigator : Navigator displays all objects that you create in the Repository Manager, the Designer, and the Workflow Manager. It is organized first by repository and by folder.
  3. Main : Provides properties of the object selected in the Navigator. The columns in this window change depending on the object selected in the Navigator
  4. Output : Provides the output of tasks executed within the Repository Manager.

Informatica PowerCenter Repository Objects

You create PowerCenter repository objects using the Designer and Workflow Manager client tools. You can view the following objects in the Navigator window of the Repository Manager:

Source definitions : Definitions of database objects such as tables, views, synonyms, or files that provide source data. Target definitions : Definitions of database objects or files that contain the target data.

Mappings : A set of source and target definitions along with transformations containing business logic that you build into the transformation. These are the instructions that the Integration Service uses to transform and move data.

Reusable transformations : Transformations that you use in multiple mappings.

Mapplets : A set of transformations that you use in multiple mappings.

Sessions and workflows : Sessions and workflows store information about how and when the Integration Service moves data. A workflow is a set of instructions that describes how and when to run tasks related to extracting, transforming, and loading data.


What is a Session?

A session is a type of task that you can put in a workflow. Each session corresponds to a single mapping.