Skip to main content

Important Repository tables in Informatica

By




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.
Labels:

Comments

Post a Comment

Popular posts from this blog

Contact Me

By
Do You have any queries ?                   If you are having any query or wishing to get any type of help related Datawarehouse, OBIEE, OBIA, OAC then please e-email on below. I will reply to your email within 24 hrs. If I didn’t reply to you within 24 Hrs., Please be patience, I must be busy in some work. kashif7222@gmail.com
3 comments
Read more

Top 130 SQL Interview Questions And Answers

By
1. Display the dept information from department table.   Select   *   from   dept; 2. Display the details of all employees   Select * from emp; 3. Display the name and job for all employees    Select ename ,job from emp; 4. Display name and salary for all employees.   Select ename   , sal   from emp;   5. Display employee number and total salary   for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees.   Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10   Select ename from emp where deptno=10; 8. Display the names of all employees working as   clerks and drawing a salary more than 3000   Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commission   Select empno,ename from emp where comm is not null and comm>0. 10
32 comments
Read more

Informatica sample project

By
Informatica sample project - 1 CareFirst – Blue Cross Blue Shield, Maryland (April 2009 – Current) Senior ETL Developer/Lead Model Office DWH Implementation (April 2009 – Current) CareFirst Blue Cross Blue Shield is one of the leading health care insurance provided in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model Office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc. The project was to provide data into EDM and to third party vendor (Verisk) to develop cubes based on data provided into EDM. I was responsible for analyzing source systems data, designing and developing ETL mappings. I was also responsible for coordinating testing with analysts and users. Responsibilities: ·          Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. ·          Understood the requirement and develope
Post a Comment
Read more