DM: Advanced Data Modeling and Architecture
Session Title: Advanced Data Modeling and Architecture Pre-requisites ü Should be aware of DBMS Concepts ü Should be aware of Data warehouse concepts ü Should be aware of Data base concepts (any database) ü Should have minimun of 2+ years of experience on any ETL Tool Table of Content 1. Data Model Overview 1.1 Prerequisites for this […]
Informatica PC HF4 Installation Steps on PC91HF3
Table of Contents Overview This document isfor informatica administration team, providing the detailed installations stepsof HotFix 4 on PC 91 HF3 Download 9.1 Software Download Softwarefrom informatica Corporation and make sure to get proper keys based onenvironment (Dev/ Prod). Backup Domain Before Startup take all backups of domainand Repositories Backup of Repositories’ Take backup of […]
How to find Sources and Targets of a Session
Please use below steps to find out source and target of a session using pmrep commands. Connect to Linux Server and log in to bin folder ($INFA_HOME/Server/bin) Connect to Repository, using below commandpmrep connect -r <REPO NAME> -d <DOMAIN NAME> -n <USER> -x <PWD> Fetch Source tables of the sessionpmrep listtablesbysess -f <Folder Name> -s <Session Name> […]
3.03 Tuning Repository Performance
Repository Analyze The PowerCenter repository has more than 170 tables, and almost all tables use at least one index to speed up queries. Most databases keep and use column distribution statistics to determine which index to use to execute SQL queries optimally. Database servers do not update these statistics continuously. In frequently used repositories, these […]
Informatica PC Upgrade from 861 to 91 Installation Steps
Table of Contents Overview This document isfor informatica administration team, providing the detailed upgradation steps from8.6.1 to 9.1 on Linux & Oracle Environment. Download 9.1 Software Download Softwarefrom informatica Corporation and make sure to get proper keys based onenvironment (Dev/ Prod). Backup Domain Before Startup of up gradation, please takebackup of 8.6.1 domain Backup of […]
Informatica PC 861 Instellation Steps
Table of Contents Overview This document is for informatica administration team, providing the detailed steps on installation of Power Center 8.6.1 on Linux & Oracle Environment. Download Software Download Software from informatica Corporation and make sure to get proper keys based onenvironment (Dev/ Prod). Setup of Database Parameters, Users & Tablespace Database Parameter Set the open_cursors parameter to 1000 […]
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 […]