INFORMATICA REPOSITORY QUERIES – PART III
INFORMATICA REPOSITORY QUERIES – PART I INFORMATICA REPOSITORY QUERIES – PART II 13 GROUPS & USERS Power Center Version 8 onwards Users and Groups details are stored in Domain database and in unreadable format. On execution of below attached scripts on domain database v_users and v_user_group views will be created and you can query on these views. […]
INFORMATICA REPOSITORY QUERIES – PART II
TABLE OF CONTENTS INFORMATICA REPOSITORY QUERIES – PART I 11 WORKFLOW 11.1 List workflow names SELECT SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME FROM REP_ALL_TASKS WHERE TASK_TYPE IN (71) –AND SUBJECT_AREA= ‘ABC’ ORDER BY 1, 2, 3 11.2 List save workflow log count SELECT DISTINCT A.SUBJECT_AREA, A.TASK_NAME AS WORKFLOW_NAME, B.ATTR_VALUE AS SAVEWFLOG FROM […]