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

1 comment:

  1. Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. big data projects for students But it’s not the amount of data that’s important.Project Center in Chennai

    Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Corporate TRaining Spring Framework the authors explore the idea of using Java in Big Data platforms.

    Spring Training in Chennai

    The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    ReplyDelete