INFORMATICA REPOSITORY QUERIES – PART IV
INFORMATICA REPOSITORY QUERIES – PART I INFORMATICA REPOSITORY QUERIES – PART II INFORMATICA REPOSITORY QUERIES – PART III 14 REPOSITORY 14.1 Repository Info SELECT DOMAIN_NAME, REPOSITORY_NAME,PCSF_DOMAIN AS DOMAIN, DB_USER FROM OPB_REPOSIT_INFO 14.2 List of objects which are Not Valid SELECT REPOSITORY,FOLDER_NAME,WORKFLOW_OR_WORKLET,TASK_TYPE, WORKLET_OR_SESSION,IS_VALID FROM (SELECT DISTINCT OPB_REPOSIT_INFO.REPOSITORY_NAME AS REPOSITORY, OPB_SUBJECT.SUBJ_NAME AS FOLDER_NAME, OPB_TASK.TASK_NAME AS WORKFLOW_OR_WORKLET, […]
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 […]
Informatica PowerCenter 8 Consultant Update Q Skill Set
Informatica PowerCenter 8 Consultant Update Q Skill Set https://docs.google.com/open?id=0BxoiTOkq3-YPeV9ZQVgtNWpRdWFtZWd6ZnZKTnk5Zw
Informatica 8x Upgrade Skill Set Exam
Informatica 8x Upgrade Skill Set Exam https://docs.google.com/open?id=0BxoiTOkq3-YPWTZRNXVKM3BRNFNYckxVWkF0V0gzdw
Informatica Data Quality 8.6 Certification Skill Set
Informatica Data Quality 8.6 Certification Skill Set https://docs.google.com/open?id=0BxoiTOkq3-YPU3R2OXUxbDVTTGFQNlA2Ym1yNVBSUQ
4.6 Informatica Data Explorer 8.6 Certification Skill Set
Informatica Data Explorer 8.6 Certification Skill Set https://docs.google.com/open?id=0BxoiTOkq3-YPWEhuclhCbXdSZUc5YUthc1kyZUx6UQ
3.23 Informatica Interview Questions Dump
Informatica Interview Questions Dump Please find below is the link where you can download Informatica Interview questions dump where I have been collecting earlier. https://docs.google.com/open?id=0BxoiTOkq3-YPN2RjMTExOGEtZjdlNi00ODdjLWJjMjEtOTdkYWI3N2M2OTVj
4.7 Informatica Data Explorer Training Guide
Informatica Data Explorer Training Guide This Document is intended on How to work on Informatica Data Explorer Tool, step by step process are given with screen shots, Please refer to Informatica corporation manuals as well. Please find below link to view my file in an attachment. https://docs.google.com/open?id=0BxoiTOkq3-YPMjE3ZDQ3NGQtYWVhMy00MTA0LWIwYTctOTcxNzc4MDk5NGIz
3.13 How to Restore Informatica Repository using Command Line Utilities
TABLE OF CONTENTS 1 Overview 2 Backup Production Repo file 3 Steps to Restore Repository 3.1 Step 1 – Connect to Dev Repository 3.2 Step 2 – Disable Dev Repo Services 3.3 Step 3 – Update Repository Service of Dev to run in Exclusive mode 3.4 […]