2 Jul 2010

Informatica 8.6 Repository queries

Repository query to fetch all the workflows which are not enabled for “Write Backward Compatible Session Log File”
Workflow Property:
select a.task_ID,TASK_NAME,c.SUBJ_NAME,ATTR_ID,ATTR_NAME,ATTR_VALUE
from REP_TASK_ATTR a,OPB_TASK b,OPB_SUBJECT c
where
a.TASK_ID=b.TASK_ID
and b.subject_id=c.SUBJ_ID
and a.task_type_name='Workflow'
and ATTR_ID='12'
and c.SUBJ_NAME ="folder name"
and ATTR_VALUE='0'
and TASK_NAME ="workflow name"
order by SUBJ_NAME,TASK_NAME
Session Property:
select TASK_NAME,c.SUBJ_NAME,ATTR_ID,ATTR_NAME,ATTR_VALUE
from REP_TASK_ATTR a,OPB_TASK b,OPB_SUBJECT c
where
a.TASK_ID=b.TASK_ID
and b.subject_id=c.SUBJ_ID
and a.task_type_name='Session'
and ATTR_ID='17'
and c.SUBJ_NAME ="folder name"
and ATTR_VALUE='0'
and b.TASK_TYPE='68'
and b.RU_PARENT_ID in (
select TASK_ID from OPB_TASK a,OPB_SUBJECT b
where
a.subject_id=b.SUBJ_ID
and TASK_NAME ="workflow name"
and b.SUBJ_NAME ="folder name")
order by SUBJ_NAME,TASK_NAME

9 comments:

  1. Thanks for your posting, which made me to join Informatica online training @ www.monstercourses.com

    ReplyDelete
  2. Pretty good post. I just came across your site and wanted to say that I’ve really enjoyed reading your posts. In any case I’ll be subscribing to your feed and I hope you will keep a good work!Cheer!

    sap online training
    software online training
    sap sd online training
    hadoop online training
    sap-crm-online-training

    ReplyDelete

  3. This is one awesome blog article. Much thanks again.
    I really enjoy the blog.Much thanks again. Really Great.


    oracle online training
    sap fico online training
    dotnet online training
    qa-qtp-software-testing-training-tutorial

    ReplyDelete
  4. Pretty great post. I just stumbled upon your blog and wished
    Thanks for some other magnificent post.for more details

    http://www.tekclasses.com/

    ReplyDelete
  5. You have posted a trust worthy blog keep sharing.
    Regards,
    http://www.tekclasses.com/

    ReplyDelete
  6. Brillant piece of information,if u r interested follow below link
    http://www.tekclasses.com/

    ReplyDelete