3.24 Informatica KT Plan Template
Hello Friends, As most of you requested, please find attached KT plan Template for Informatica Admin Role. https://drive.google.com/open?id=0BxoiTOkq3-YPVjFuZ3NzSzVtazQ
2.01 PC install 711
Hello Friends, Based on requests from few of you, here is the attached Installation Steps for Informatica 7.1.1 on Windows Platform. https://drive.google.com/open?id=0BxoiTOkq3-YPVUczUEdCQ1VZRXM
1.01 Domain Level Queries
1.1 Check Master Domain Election of Node (on Multi Node Setup) Select * from ISP_MASTER_ELECT_LOCK 1.2 Check Master Selection of Host, Node and Port Details (Domain tables) Select * from ISP_MASTER_ELECTION 1.3 Repository Information SELECT PCSF_DOMAIN AS DOMAIN, REPOSITORY_NAME, DB_USER FROM OPB_REPOSIT_INFO 1.4 List Service Names, Grid, License Name and Service Type (Domain tables) SELECT […]
1.04 Deployment Groups
4.1 Informatica Queries for Deployment Groups 1. Deployment Details Displays, by group name, type, and creator, the details of the deployed objects by a particular deployment group. This report is the first node in the analytic workflow associated with the Deployment Group History primary report. SELECT DEP_GROUP_NAME, REPOSITORY_NAME, […]
1.05 INFORMATICA FOLDERS
5.1 List folder details SELECT SUBJ_NAME,SUBJ_DESC FROM OPB_SUBJECT ORDER BY 1,2 5..2List of shared folders SELECT SUBJ_NAME,SUBJ_DESC FROM OPB_SUBJECT WHERE IS_SHARED 0 ORDER BY 1,2 5.3 List of Users and groups having privileges’ on Folders SELECT(select repository_name from OPB_REPOSIT_INFO) repo_name,subj.subj_name folder_name, user_group.NAME user_name, DECODE (obj_access.user_type, 1, ‘USER’, 2, ‘GROUP’) TYPE, CASE WHEN ((obj_access.permissions – (obj_access.user_id […]
1.06 INFORMATICA TABLES
6.1 List where a table is used Sometimes you want to know if certain tables are listed in sql overrides of Source Qualifier or Lookup transformation. This helps you identifying dependencies. The query below will list folder, attribute type and sql override as output. SELECT DISTINCT REP_ALL_MAPPINGS.SUBJECT_AREA, REP_ALL_MAPPINGS.MAPPING_NAME,REP_WIDGET_ATTR.ATTR_NAME, REP_WIDGET_ATTR.ATTR_VALUE FROM REP_WIDGET_ATTR, REP_WIDGET_INST, REP_ALL_MAPPINGS WHERE […]
1.07 SOURCE TABLES
7.1 List of source tables SELECT B.SUBJ_NAME, C.DBDNAM, D.DBTYPE_NAME, A.SOURCE_NAME AS TABLE_NAME, A.FILE_NAME SCHEMA_NAME, A.OWNERNAME FROM OPB_SRC A,OPB_SUBJECT B, OPB_DBD C,OPB_MMD_DBTYPE D WHERE A.SUBJ_ID = B.SUBJ_ID AND A.DBDID = C.DBDID AND C.DBTYPE = D.DBTYPE_ID –AND A.SOURCE_NAME A.FILE_NAME ORDER BY 1,2,3,4,5 7.2 List and count of tables in each folder by db type SELECT B.SUBJ_NAME, D.DBTYPE_NAME, […]
1.09 TRANSFORMATIONS
9.1 List All Transformations used in Folder Level SELECT DISTINCT SUBJECT_AREA AS FOLDER_NAME, PARENT_WIDGET_NAME AS TRANS_NAME, WIDGET_TYPE_NAME AS TRANS_TYPE FROM REP_ALL_TRANSFORMS ORDER BY 1,2,3 9.2 List all Transformations with Transformation type SELECT DISTINCT SUBJECT_AREA, WIDGET_TYPE_NAME, PARENT_WIDGET_NAME FROM REP_ALL_TRANSFORMS WHERE WIDGET_TYPE_NAME =’Aggregator’ ORDER BY 1,2 9.3 List Sequence Generator Value SELECT a.attr_value AS current_value, […]
1.15 Workflows
15.1 List of workflow run statistics SELECT DISTINCT OPB_SUBJECT.SUBJ_NAME,OPB_WFLOW_RUN.WORKFLOW_NAME, OPB_TASK_INST_RUN.INSTANCE_NAME, TRUNC(OPB_TASK_INST_RUN.START_TIME) LOAD_DATE, TO_CHAR(OPB_TASK_INST_RUN.START_TIME,’HH24:MI.SS’) SESS_START_TIME, TO_CHAR(OPB_TASK_INST_RUN.END_TIME,’HH24:MI.SS’) SESS_END_TIME, TRUNC((OPB_TASK_INST_RUN.END_TIME – OPB_TASK_INST_RUN.START_TIME) * 1440,2) DURATION_IN_MINS FROM OPB_SUBJECT,OPB_TASK_INST_RUN,OPB_WFLOW_RUN,OPB_OBJECT_TYPE, OPB_SESS_TASK_LOG WHERE OPB_SUBJECT.SUBJ_ID = OPB_TASK_INST_RUN.SUBJECT_ID AND OPB_WFLOW_RUN.WORKFLOW_ID = OPB_TASK_INST_RUN.WORKFLOW_ID AND OPB_WFLOW_RUN.WORKFLOW_RUN_ID = OPB_TASK_INST_RUN.WORKFLOW_RUN_ID AND OPB_TASK_INST_RUN.TASK_TYPE = OPB_OBJECT_TYPE.OBJECT_TYPE_ID AND OPB_OBJECT_TYPE.OBJECT_TYPE = 68 AND OPB_WFLOW_RUN.WORKFLOW_ID = OPB_SESS_TASK_LOG.WORKFLOW_ID AND OPB_WFLOW_RUN.WORKFLOW_RUN_ID = OPB_SESS_TASK_LOG.WORKFLOW_RUN_ID AND OPB_TASK_INST_RUN.WORKLET_RUN_ID […]
1.12 Sessions
12.1 List session names SELECT SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME FROM REP_ALL_TASKS WHERE TASK_TYPE IN (68) –AND SUBJECT_AREA= ‘ABC’ ORDER BY 1, 2, 3 12.2 List “save session log” runs select distinct cc.subject_area,cc.task_name as session_name,bb.attr_value as Savesessionlog from (select a.session_id,min(a.config_id) as config_id,a.attr_id from rep_sess_config_parm a where a.attr_id = ‘103’ group by a.session_id,a.attr_id) aa, (select session_id,config_id,attr_value from rep_sess_config_parm […]