✍ Kashif M
Trends

Sunday, 6 September 2015


Query related to task in informatica


By on September 06, 2015


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


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


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

Kashif
mkashu: Query related to task in informatica
Review : Kashif | Kashif
Update: September 06, 2015 | Rating: 4.5

Comment for "Query related to task in informatica"

0 comments

Post a Comment

Blog Archive