Di seguito una query per poter associare i workflow ai mapping eseguiti in Informatica.
Tutto internamente ad Informatica:
-------------------------------------------------------------------
--- QUERY ESTRAZIONE associativa WF_MAPPING in INFORMATICA ---
--- Da eseguire come utente sys sul database che contiene il repository di INFORMATICA ---
-------------------------------------------------------------------
SELECT distinct
SUB.SUBJ_NAME subject_area_info ,
WF.WORKFLOW_NAME, opb_task.TASK_NAME task_name_info,
OPB_TASK_INST.INSTANCE_NAME ,MAP.MAPPING_NAME
,MAP.MAPPING_ID, opb_task.IS_VALID, opb_task.IS_ENABLED,
OPB_OBJECT_TYPE.OBJECT_TYPE_NAME TASK_TYPE_NAME
FROM
INFA.OPB_TASK_INST,
INFA.OPB_OBJECT_TYPE,
INFA.OPB_TASK,
INFA.REP_WORKFLOWS WF,
INFA.OPB_SUBJECT SUB,
INFA.OPB_SESSION SESS,
INFA.OPB_MAPPING map
WHERE
OPB_TASK_INST.TASK_TYPE = OPB_OBJECT_TYPE.OBJECT_TYPE_ID
AND OPB_TASK_INST.WORKFLOW_ID = OPB_TASK.TASK_ID
AND OPB_TASK_INST.VERSION_NUMBER = OPB_TASK.VERSION_NUMBER
AND OPB_TASK.IS_VISIBLE = 1
AND WF.WORKFLOW_ID=OPB_TASK_INST.WORKFLOW_ID
AND WF.SUBJECT_ID=SUB.SUBJ_ID
AND OPB_TASK.SUBJECT_ID=SUB.SUBJ_ID
AND SUB.SUBJ_ID=WF.SUBJECT_ID
AND OPB_TASK_INST.TASK_ID=SESS.SESSION_ID
AND MAP.MAPPING_ID=SESS.MAPPING_ID
AND MAP.SUBJECT_ID=WF.SUBJECT_ID
AND MAP.IS_VALID=1
