query to get relation connection details in Informatica
Below is the query to get relation connection details in Informatica.
select * from V_PC8X_CONNECTION where CONNECTION_NAME IN
(select DISTINCT CONNECTION_NAME from REP_SESSION_CNXS where SUBJECT_AREA='FOLDER_NAME');
If you want to get connection details used in particular folder then you need to pass the FOLDER_NAME as input to the above query.
Above query will give details like Connection name, Host name, database type, user name, Connection string and more.
select * from V_PC8X_CONNECTION where CONNECTION_NAME IN (select DISTINCT CONNECTION_NAME from REP_SESSION_CNXS where SUBJECT_AREA='FOLDER_NAME');
If you want to get connection details used in particular folder then you need to pass the FOLDER_NAME as input to the above query. Above query will give details like Connection name, Host name, database type, user name, Connection string and more. Informatica Repository Queries to get connection names, command tasks and event wait file names
Query to get folder name, workflow name, session names and all the connections used in sessions.
SELECT WF.SUBJECT_AREA AS FOLDER_NAME, WF.WORKFLOW_NAME AS WORKFLOW_NAME, T.INSTANCE_NAME AS SESSION_NAME, T.TASK_TYPE_NAME, C.CNX_NAME AS CONNECTION_NAME, V.CONNECTION_SUBTYPE, V.HOST_NAME, V.USER_NAME, C.INSTANCE_NAME, C.READER_WRITER_TYPE, C.SESS_EXTN_OBJECT_TYPE FROM REP_TASK_INST T, REP_SESS_WIDGET_CNXS C, REP_WORKFLOWS WF, V_IME_CONNECTION V WHERE T.TASK_ID = C.SESSION_ID AND WF.WORKFLOW_ID = T.WORKFLOW_ID AND C.CNX_NAME = V.CONNECTION_NAME AND WF.SUBJECT_AREA =
Note: If SESS_EXTN_OBJECT_TYPE=78 then its reader, If 79 then its writer
Query to get commands used in command tasks including the commands used as pre/post session commands
SELECT DISTINCT T.SUBJECT_ID, F.SUBJECT_AREA AS FOLDER_NAME, W.TASK_NAME AS WORKFLOW_NAME, T.TASK_NAME AS CMD_TASK_NAME, CMD.PM_VALUE AS CMD_NAME, CMD.EXEC_ORDER, CMD.VAL_NAME AS CMD_NUMBER, T.TASK_ID, T.TASK_TYPE, T.RU_PARENT_ID FROM OPB_TASK_VAL_LIST CMD, OPB_TASK T, OPB_TASK W, REP_SUBJECT F WHERE T.TASK_ID = CMD.TASK_ID AND T.SUBJECT_ID = F.SUBJECT_ID AND T.TASK_TYPE = 58 AND T.RU_PARENT_ID = W.TASK_ID AND F.SUBJECT_AREA = ORDER BY F.SUBJECT_AREA, W.TASK_NAME, T.TASK_NAME, CMD.EXEC_ORDER
select * from V_PC8X_CONNECTION where CONNECTION_NAME IN
(select DISTINCT CONNECTION_NAME from REP_SESSION_CNXS where SUBJECT_AREA='FOLDER_NAME');
If you want to get connection details used in particular folder then you need to pass the FOLDER_NAME as input to the above query.
Above query will give details like Connection name, Host name, database type, user name, Connection string and more.
select * from V_PC8X_CONNECTION where CONNECTION_NAME IN (select DISTINCT CONNECTION_NAME from REP_SESSION_CNXS where SUBJECT_AREA='FOLDER_NAME');
If you want to get connection details used in particular folder then you need to pass the FOLDER_NAME as input to the above query. Above query will give details like Connection name, Host name, database type, user name, Connection string and more. Informatica Repository Queries to get connection names, command tasks and event wait file names
Query to get folder name, workflow name, session names and all the connections used in sessions.
SELECT WF.SUBJECT_AREA AS FOLDER_NAME, WF.WORKFLOW_NAME AS WORKFLOW_NAME, T.INSTANCE_NAME AS SESSION_NAME, T.TASK_TYPE_NAME, C.CNX_NAME AS CONNECTION_NAME, V.CONNECTION_SUBTYPE, V.HOST_NAME, V.USER_NAME, C.INSTANCE_NAME, C.READER_WRITER_TYPE, C.SESS_EXTN_OBJECT_TYPE FROM REP_TASK_INST T, REP_SESS_WIDGET_CNXS C, REP_WORKFLOWS WF, V_IME_CONNECTION V WHERE T.TASK_ID = C.SESSION_ID AND WF.WORKFLOW_ID = T.WORKFLOW_ID AND C.CNX_NAME = V.CONNECTION_NAME AND WF.SUBJECT_AREA =
Note: If SESS_EXTN_OBJECT_TYPE=78 then its reader, If 79 then its writer
Query to get commands used in command tasks including the commands used as pre/post session commands
SELECT DISTINCT T.SUBJECT_ID, F.SUBJECT_AREA AS FOLDER_NAME, W.TASK_NAME AS WORKFLOW_NAME, T.TASK_NAME AS CMD_TASK_NAME, CMD.PM_VALUE AS CMD_NAME, CMD.EXEC_ORDER, CMD.VAL_NAME AS CMD_NUMBER, T.TASK_ID, T.TASK_TYPE, T.RU_PARENT_ID FROM OPB_TASK_VAL_LIST CMD, OPB_TASK T, OPB_TASK W, REP_SUBJECT F WHERE T.TASK_ID = CMD.TASK_ID AND T.SUBJECT_ID = F.SUBJECT_ID AND T.TASK_TYPE = 58 AND T.RU_PARENT_ID = W.TASK_ID AND F.SUBJECT_AREA = ORDER BY F.SUBJECT_AREA, W.TASK_NAME, T.TASK_NAME, CMD.EXEC_ORDER
Comments
Post a Comment