1.13 Tasks
13.1 List Command tasks SELECT SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME FROM REP_ALL_TASKS WHERE TASK_TYPE IN (58) –AND SUBJECT_AREA= ‘ABC’ ORDER BY 1, 2, 3 13.2 List Decision tasks SELECT SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME FROM REP_ALL_TASKS WHERE TASK_TYPE IN (59) –AND SUBJECT_AREA= ‘ABC’ ORDER BY 1, 2, 3 13.3 List Event Wait tasks SELECT SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME […]
1.14 Worklets
14.1 List worklet names SELECT SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME FROM REP_ALL_TASKS WHERE TASK_TYPE IN (70) –AND SUBJECT_AREA= ‘ABC’ ORDER BY 1, 2, 3 14.2 List hierarchies of all workflows and its worklets SELECT DISTINCT ‘/’ || temp1.task_id AS path, temp1.task_name AS hierarchy_structure FROM opb_task temp1, opb_subject temp2 WHERE temp1.subject_id = temp2.subj_id AND temp1.task_type = 71 […]
1.16 Connections
16.1 List Connection Name and Connect Type SELECT DISTINCT CONNECTION_TYPE, CONNECTION_NAME, CONNECTION_SUBTYPE, HOST_NAME, USER_NAME, SCHEMA_NAME, ADDRESS FROM V_PC8X_CONNECTION ORDER BY 1,2 16.2 List of all Connections SELECT DISTINCT (select repository_name from OPB_REPOSIT_INFO) as REPO, CASE when a.OBJECT_SUBTYPE = 0 then ‘FTP’ when a.OBJECT_SUBTYPE = 101 then ‘Oracle’ when a.OBJECT_SUBTYPE = 102 then ‘Sybase’ when a.OBJECT_SUBTYPE […]
1.17 Users and Groups
17.1 List Execute Locks on Objects in Folder Level SELECT SUBJ_NAME FOLDER, CNX_ID, DECODE ( LOCK_TYPE, 1, ‘NodeInUseLock’, 2, ‘NodeWriteIntentLock’, 4, ‘ExecuteLock’, 5, ‘SharedLock’, 6, ‘ExclusiveLock’, 7, ‘SubTreeSharedLoc’, 8, ‘SubTreeExclusiveLock’, 9, ‘SubTreeISharedLock’, 10, ‘SubTreeIExclusiveLock’, 11, ‘SubTreeWriteIntentLock’, 12, ‘SubTreeIWriteIntentLock’ ) LOCK_TYPE FROM OPB_OBJECT_LOCKS L, OPB_SUBJECT S WHERE L.SUBJECT_ID = SUBJ_ID and lock_type = 4 –and SUBJ_NAME […]
Informatica Metadata Queries – 15 SCHEDULER
15.1 Check Scheduled workflows using pmcmd command pmcmd getservicedetails -sv etltst222_iserv -d domain_ etltst222-u Administrator -p Administrator –scheduled 15.2 List all Scheduled Workflow details SELECT SUBJECT_AREA, WORKFLOW_NAME, SCHEDULER_NAME, START_TIME, END_TIME, CASE WHEN RUN_OPTIONS = 1 THEN ‘RUN ON DEMAND’ WHEN RUN_OPTIONS = 2 THEN ‘RUN ONCE’ WHEN […]
1.18 Integration Services
18.1 How to delete unwanted Integration Services (seen in wf Monitor) 1 Take back up of the following tables Create table OPB_SESS_TASK_LOG_20151020 as select * from OPB_SESS_TASK_LOG ; Create table OPB_SWIDGINST_LOG_20151020 as select * from OPB_SWIDGINST_LOG ; Create table OPB_DTL_SWIDG_LOG_20151020 as select * from OPB_DTL_SWIDG_LOG ; Create table OPB_TASK_INST_RUN_20151020 as select * from OPB_TASK_INST_RUN ; […]
EDF – Edifecs 8.6 Installation Steps
Edifecs 8.6 Installation Steps INDEX Introduction Pre-Requisites 2.1. Update .profile Edifecs software installation HIPPA 3.1. HIPAA Standards install 3.2. ECL standards install 3.3. X12N standards install 3.4. XEngine install6 3.5. XEServer install 3.6. XEServer hotfix install 3.7. XEServer license install 3.8. EAM Install 3.9. Update the EAM server port number Start EAM Server EAM HotFix […]
3.06 Power Center Web Service Log Run Details
Power Center Web Service Log Run Details Power Center Web service log run details will be fetched under below folders on Server, these run details cannot be fetched in Informatica metadata. These stats are not stored in repository. They are stored on the file system in /tomcat/temp//logs directory Also make sure to increase […]
3.11 Increase Active Informatica Admin Console Page Timeout
Increase Active Informatica Admin Console Page Timeout Informatica Administrator usually when they work on multiple tasks, want Informatica admin console page to be open for a long time, by default console page will be disconnected every 30 seconds and have to re login again. By increasing timeout in below file, admin console […]
3.01 Optimize Domain and Repository Size and Performance
Informatica Admin team will receive concerns from developers saying that development repository performance is too bad and have issues to work on their regular tasks on daily wise, so as administrator its admin responsibly to review issues and fix, below are some of my findings where this could help in improving of performance. Also […]