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