Tutorial corner

Informatica,ETL,oracle,sql/plsql

Informatica Repository Manager in PowerCenter Client

Spread the love

Informatica Repository Manager : In our last post ,we started with discussion of Informatica PowerCenter Client. Out of 5 components , Repository Manager in informatica is the main component responsible for creating and storing  metadata of all objects. In this article , we will go through the details of Informatica Repository Maneger along with its component and their purpose.

Repository Manager Tasks

Use the Repository Manager to administer repositories. You can navigate through multiple folders and repositories, and complete the following tasks:

Manage user and group permissions : Assign and revoke folder and global object permissions.

Perform folder functions : Create, edit, copy, and delete folders. Work you perform in the Designer and Workflow Manager is stored in folders. If you want to share metadata, you can configure a folder to be shared.

View metadata :  Analyse sources, targets, mappings, and short-cut dependencies, search by keyword, and view the properties of repository objects.

Windows in Repository Manager

While opening Informatica Repository Manager you will see below windows

Informatica Repository Manager

Informatica Repository Manager

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.

Main Window : Provides properties of the object selected in the Navigator. The columns in this window change depending on the object selected in the Navigator.

Output  Window :  Provides the output of tasks executed within the Repository Manager.

Repository Manager Objects

You create 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. A session is a type of task that you can put in a workflow. Each session corresponds to a single mapping.

The Author

Alisha Lamba

Hello Friends , I am Alisha Lamba .I love to write article on latest technologies like Informatica , ETL , data warehouse , SQL-PL SQL
Copyright 2015 - Tutorial Corner Frontier Theme