Author: bimaldhanu

Informatica PC 9.1 Installation Steps

Table of Contents Overview  This document is for informatica administration team, providing the detailed steps on installation of Power Center 9.1 on Linux & Oracle Environment. Download Software Download Software from informatica Corporation and make sure to get proper keys based on environment (Dev/ Prod). Setup of Database Parameters, Users & Tablespace Database Parameter Set the open_cursors […]

3.16 WORKING WITH PMREP COMMANDS

            1          Working with pmrep commands        1.1       Connect to Repository            1.2       ListObjects      1.2.1    Workflow 1.2.2    Source 1.2.3    Target 1.2.4    Mapplet          1.2.5    Transformation           1.2.6    Worklet           1.2.7    Stored Procedures      1.2.8    Reusable Sessions       1.2.9    All Folders       1.2.10  List User Connections 1.2.11  Listing Tables by Session (Listtablesbysess)    1.2.12  Listing Dependencies  1.3       Export Object  1.3.1    Source 1.3.2    Target 1.3.3    Transformation           […]

INFORMATICA REPOSITORY QUERIES – PART V

INFORMATICA REPOSITORY QUERIES – PART I INFORMATICA REPOSITORY QUERIES – PART II INFORMATICA REPOSITORY QUERIES – PART III INFORMATICA REPOSITORY QUERIES – PART IV   16        SCHEDULER  16.1           Check Scheduled workflows using pmcmd command   Command Prompt: pmcmd getservicedetails -sv etltst222_iserv -d domain_ etltst222-u Administrator -p Administrator –scheduled 16.2           Check Scheduled workflows using queries Query: […]

3.02 Tuning Sessions for Better Performance

 Tuning Sessions for Better Performance Challenge Running sessions is where the pedal hits the metal. A common misconception is that this is the area where most tuning should occur. While it is true that various specific session options can be modified to improve performance, PowerCenter 8 comes with PowerCenter Enterprise Grid Option and Pushdown optimizations […]

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 […]

About
Legal
Trending Topics
  • Facebook
  • Instagram
  • LinkedIn
  • X Twitter
  • YouTube
© 2024 ETL Tech Blog. All rights reserved.