Friday, January 20, 2017

Informatica Metadata Queries - 10 TASKS



10.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

10.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

10.3         List Event Wait tasks


SELECT   SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
    FROM REP_ALL_TASKS
   WHERE TASK_TYPE IN (60) 
         --AND SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3

10.4         List Event Raise tasks


SELECT   SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
    FROM REP_ALL_TASKS
   WHERE TASK_TYPE IN (61) 
         --AND SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3

10.5         List Start tasks


SELECT   SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
    FROM REP_ALL_TASKS
   WHERE TASK_TYPE IN (62) 
         --AND SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3

10.6         List Email tasks


SELECT   SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
    FROM REP_ALL_TASKS
   WHERE TASK_TYPE IN (65) 
         --AND SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3

10.7         List Timer tasks


SELECT   SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
    FROM REP_ALL_TASKS
   WHERE TASK_TYPE IN (66) 
         --AND SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3


10.8         List Assignment tasks


SELECT   SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
    FROM REP_ALL_TASKS
   WHERE TASK_TYPE IN (67) 
         --AND SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3



10.9         List Session tasks


SELECT   SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
    FROM REP_ALL_TASKS
   WHERE TASK_TYPE IN (60) 
         --AND SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3

10.10      List Control tasks


SELECT   SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
    FROM REP_ALL_TASKS
   WHERE TASK_TYPE IN (91) 
         --AND SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3

10.11      List Command Task Value


SELECT distinct a.SUBJECT_AREA,a.TASK_NAME,a.TASK_TYPE_NAME,
b.pm_value, b.val_name
    FROM REP_ALL_TASKS a,  opb_task_val_list b
   WHERE a.TASK_TYPE IN (58,59,60,65, 66,68,70,71)
   and  a.task_id = b.task_id    

ORDER BY 1, 2, 3