✍ Kashif M
Trends

Sunday, 6 September 2015


Important Repository tables in Informatica


By on September 06, 2015





1. OPB_SUBJECT - PowerCenter folders table

This table stores the name of each PowerCenter repository folder.

Usage: Join any of the repository tables that have SUBJECT_ID as column with that

of SUBJ_ID in this table to know the folder name.



2. OPB_MAPPING - Mappings table

This table stores the name and ID of each mapping and its corresponding folder.

Usage: Join any of the repository tables that have MAPPING_ID as column with that

of MAPPING_ID in this table to know the mapping name.



3. OPB_TASK - Tasks table like sessions, workflow etc

This table stores the name and ID of each task like session, workflow and its

corresponding folder.

Usage: Join any of the repository tables that have TASK_ID as column with that of

TASK_ID/SESSION_ID in this table to know the task name. Observe that the session

and also workflow are stored as tasks in the repository. TASK_TYPE for session is 68

and that of the workflow is 71.



4. OPB_SESSION - Session & Mapping linkage table

This table stores the linkage between the session and the corresponding mapping. As

informed in the earlier paragraph, you can use the SESSION_ID in this table to join

with TASK_ID of OPB_TASK table.



5. OPB_TASK_ATTR - Task attributes tables

This is the table that stores the attribute values (like Session log name etc) for tasks.

Usage: Use the ATTR_ID of this table to that of the ATTR_ID of OPB_ATTR table to

find what each attribute in this table means. You can know more about OPB_ATTR

table in the next paragraphs.



6. OPB_WIDGET - Transformations table

This table stores the names and IDs of all the transformations with their folder

details.

Usage: Use WIDGET_ID from this table to that of the WIDGET_ID of any of the

tables to know the transformation name and the folder details. Use this table in

conjunction with OPB_WIDGET_ATTR or OPB_WIDGET_EXPR to know more about

each transformation etc.



7. OPB_WIDGET_FIELD - Transformation ports table

This table stores the names and IDs of all the transformation fields for each of the

transformations.

Usage: Take the FIELD_ID from this table and match it against the FIELD_ID of any

of the tables like OPB_WIDGET_DEP and you can get the corresponding information.



8. OPB_WIDGET_ATTR - Transformation properties table

This table stores all the properties details about each of the transformations.

Usage: Use the ATTR_ID of this table to that of the ATTR_ID of OPB_ATTR table to

find what each attribute in this transformation means.



9. OPB_EXPRESSION - Expressions table

This table stores the details of the expressions used anywhere in PowerCenter.

Usage: Use this table in conjunction with OPB_WIDGET/OPB_WIDGET_INST and

OPB_WIDGET_EXPR to get the expressions in the Expression transformation for a

particular, mapping or a set.



10. OPB_ATTR - Attributes

This table has a list of attributes and their default values if any. You can get the

ATTR_ID from this table and look it up against any of the tables where you can get

the attribute value. You should also make a note of the ATTR_TYPE,

OBJECT_TYPE_ID before you pick up the ATTR_ID. You can find the same ATTR_ID

in the table, but with different ATTR_TYPE or OBJECT_TYPE_ID.



11. OPB_COMPONENT - Session Component

This table stores the component details like Post-Session-Success-Email, commands

in Post-Session/pre-Session etc.

Usage: Match the TASK_ID with that of the SESSION_ID in OPB_SESSION table to

get the SESSION_NAME and to get the shell command or batch command that is

there for the session, join this table with OPB_TASK_VAL_LIST table on TASK_ID.



12. OPB_CFG_ATTR - Session Configuration Attributes

This table stores the attribute values for Session Object configuration like "Save



Session log by", Session log path etc.

Kashif
mkashu: Important Repository tables in Informatica
Review : Kashif | Kashif
Update: September 06, 2015 | Rating: 4.5

Comment for "Important Repository tables in Informatica"

0 comments

Post a Comment