4.9 BDM List Workflow Running Processes
BDM List Workflow Running Processes ./infacmd.sh wfs listRunningProcesses -dn DOMAIN -unadmin -pd admin -sn DIS_BDMPROD >> listRunningProcesses.txt
4.10 BDM – List Active Workflow Instances
List Active Workflow Instances ./infacmd.sh wfs listactiveworkflowinstances -dn DOMAIN-un admin -pd admin -sn DIS_BDMPROD >> listactiveworkflowinstances.txt
4.11 BDM Metadata Queries
1.1 Application name and object information select app_id, app_name,Feature_name from MRX_APP_DETAILS order by 1,2, 3 asc 1.2 Application summary and path details select project_name, Parent_Path, App_name from MRX_APP_SUMMARY order by 1,2,3 1.3 Connections and Connection types select * from MRX_CONNECTIONS 1.4 Mapping Information Select project_name,Parent_path,Mapping_name from MRX_MAPPINGS 1.5 List data objects for each mapping. Select […]
4.01 Informatica PowerExchange 10.2.0 HF2 Installation.
Informatica PowerExchange 10.2.0 HotFix 2 Installation. Update Environment variables # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/binexport JAVA_HOME=/etc/alternatives/jreexport PATH=$PATH:$JAVA_HOME/bin #Set up the Informatica variables export PWX_HOME=/pwx/informatica/pwx_1011export PWX_LICENSE=/pwx/informatica/pwxpub/pwxcdcpub100_linux_x64/license.keyexport PWXPUB_HOME=/pwx/informatica/pwxpub/pwxcdcpub100_linux_x64 # Set up the environment variables export IATEMPDIR=/home/tmpexport LD_LIBRARY_PATH=$PWX_HOMEexport PATH=$PATH:$PWX_HOME:$PWXPUB_HOME/bin Begin Installation: [User@pwxSerever1001]:/pwx/informatica/pwx1020 # ./install.sh *************************************************** Welcome – Step 1 of 6 *************************************************** [ Type ‘back’ to […]
1.03 Version History
3.1 List Object Version History of Informatica Objects Displays all versions of an object by the date the object is saved in the repository. This is a stand-alone report. SELECT USER_NAME, COMMENTS, OBJECT_NAME, SAVED_FROM, OBJECT_TYPE, […]
3.05 Collect Statistics on Oracle Repository Tables
Collect Statistics on Oracle Repository Tables Collect statistics on your Power Centerrepository databases this will help to improve performance of fetches andwrites of repository data. Follow below steps. Execute below queries: select ‘analyze table ‘, table_name, ‘ compute statistics;’ from user_tables wheretable_name like ‘OPB_%’ select ‘analyze index ‘, INDEX_NAME, ‘ compute statistics;’ from […]
3.10 How to Identify Throughput Issues
How to Identify Throughput Issues Ideally, how do you determine if your performance issues is due toread or write throughput of your session? Below are few typical issues thatresult in poor performance (low throughput values) TargetCommit Point is too small The default target commit point of 10000 is used when processinglarge data volumes. This results in commits […]
3.08 DTM Buffer Size
DTM Buffer Size Typically, the DTM Buffer Size is set to Auto, and the Auto MemorySettings are used to determine the value here. Occasionally it is useful to setthis higher, but never lower than the Auto Memory value of 512 MB. In olderversion of PowerCenter, or for sessions that are auto-generated, the value istypically set […]
3.09 Auto Memory Settings
Auto Memory Settings in Session Level The session have settings for Maximum Memory Allowed for AutoMemory Attributes and Maximum Percentage Allowed for Auto Memory Attributes.Whichever is smaller is the amount used for items like the DTM buffer size,lookup cache, and other settings. The default is 512MB and 5% of the availableserver memory, whichever is […]
3.07 Informatica NFS File Systems
Informatica NFS File Systems Hello All, As Informatica administrator, recommend admins to know information on file systems (Shared) on Informatica Servers, most of thejobs read/write on share shared file systems and this will cause Latency injobs and performance is degraded. Below are few inputs on NFS from Informatica,please make sure to discuss with […]