Sunday, April 29, 2012

The (7) essentials of Informatica Repository

Here are few handy tips that will help you to understand informatica repository.For those who have limited Informatica experience but starting on tool to write etl code. Also, stated some helpful metadata views.
#1. Repository is a generic term referred to container, place or room where something is stored.
#2. Informatica repository is a set of database tables where informatica stores its metadata. METADATA is data that describes other data.More specifically it is data about data.
#3. Informatica repository keeps Informatica Meta data.Information about different type of objects, Example mappings, transformations, Folders, connections, user privileges etc.
#4. Informatica repository metadata tables in industry also called as OPB tables/views or REP tables/views.
#5. Repository is managed with client tool “informatica power center repository manager”. Repository manager is useful for ADMIN activities.
1      You can create, edit and delete folders.
2      You can manage object and user permissions.
3      You can backup repository to local machine and restore it back to some other server.
4      You can create deployment group.
5      You can view objects and their locks as well you can disable write intent lock on the objects locked by you.
6      You can import and export objects.
7      You can copy objects from one folder to another.

Important informatica repository views

Here is run-down of some useful repository views. Repository views helps to perform analysis in applications where you are on code maintenance/ enhancement role. With no assumptions, impact analysis can be achieved.

#6. REP_WFLOW_RUN
It helps to have easy consolidated workflow run statistics. You can capture run statistics of all the WFs for a day. Pick failed and aborted workflows. Recover high  priority  workflows first and rest later.
#7. REP_ALL_TRANSFORMS,REP_WIDGET_ATTR
Join of these tables gives all the lookup in a folder. it also tells that which DB tables those lookup are poiting to. you can use it to understand which is the most important lookup table  in a folder/Project. Also, how many lookup need to change, if your lookup table is changing.
Informatica repository architecture

0 comments:

Post a Comment

newer post older post Home