Wednesday, August 7, 2019

BDM List Workflow Running Processes


BDM List Workflow Running Processes


./infacmd.sh wfs listRunningProcesses -dn DOMAIN -un admin -pd admin -sn DIS_BDMPROD >> listRunningProcesses.txt

BDM - List Active Workflow Instances


List Active Workflow Instances

./infacmd.sh wfs listactiveworkflowinstances -dn DOMAIN -un admin -pd admin -sn DIS_BDMPROD >> listactiveworkflowinstances.txt

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 * from MRX_MAP_SRCCNT


1.6          List Project and Objects details.


Select Project_name,object_name,object_path from MRX_OBJECT_SUMMARY


1.7          List Physical Data Objects in a Project


select project_name,Parent_path,PDO_name as "Physical_data_Object" from MRX_PDO 


1.8          List of Application Deployed on DIS.

select dis_name,app_name,design_app_name from MRX_RT_APP_SUMRT
order by 1,2,3


1.9          List source and mapping information

Select  MAPPING_NAME,DOINST_NAME, DATA_OBJECT_NAME, DATA_OBJECT_TYPE from MRX_TX_SOURCES

Friday, June 14, 2019

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/bin
export JAVA_HOME=/etc/alternatives/jre
export PATH=$PATH:$JAVA_HOME/bin


#Set up the Informatica variables

export PWX_HOME=/pwx/informatica/pwx_1011
export PWX_LICENSE=/pwx/informatica/pwxpub/pwxcdcpub100_linux_x64/license.key
export PWXPUB_HOME=/pwx/informatica/pwxpub/pwxcdcpub100_linux_x64

# Set up the environment variables

export  IATEMPDIR=/home/tmp
export LD_LIBRARY_PATH=$PWX_HOME
export PATH=$PATH:$PWX_HOME:$PWXPUB_HOME/bin



Begin Installation: 


[User@pwxSerever1001]:/pwx/informatica/pwx1020 # ./install.sh


******************************************************************************************************
Welcome - Step 1 of 6
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check the help contents for this panel or 'quit' to cancel the installation at any time. ]

Welcome to the Informatica PowerExchange 10.2.0 HotFix 2 installer.

Copyright (c) 1993-2019 Informatica LLC. All Rights Reserved.
See patents at https://www.informatica.com/legal/patents.html
Press to continue ...


******************************************************************************************************
Enter License Key - Step 2 of 6
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check the help contents for this panel or 'quit' to cancel the installation at any time. ]


Please enter the 44 or 64 character License key(including hyphens) in upper or lower case :Provide Key received by Informatica Vendor.


******************************************************************************************************
Installation Directory - Step 3 of 6
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check the help contents for this panel or 'quit' to cancel the installation at any time. ]


Choose the installation directory (default :- /home/Informatica/PowerExchange10.2.0) :/pwx/informatica/PowerExchange10.2.0


******************************************************************************************************
Pre-Installation Summary - Step 4 of 6
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check the help contents for this panel or 'quit' to cancel the installation at any time. ]


Product Name     :      Informatica PowerExchange 10.2.0 HotFix 2

Installation Directory   :      /pwx/informatica/PowerExchange10.2.0

Disk Space Requirements

Required Disk Space      :      275 MB

Available Disk Space     :      54,436 MB

Press to continue ...


******************************************************************************************************
Installing - Step 5 of 6
******************************************************************************************************


Installing... 5%

Installing... 20%

Installing... 25%

Installing... 30%

Installing... 35%

Installing... 40%

Installing... 45%

Installing... 55%

Installing... 65%

Installing... 70%

Installing... 75%

Installing... 80%

Installing... 100%

******************************************************************************************************
Post-Installation Summary - Step 6 of 6
******************************************************************************************************
Installation Status SUCCESS

Informatica PowerExchange 10.2.0 HotFix 2 installation completed successfully

For more information, see the debug log file:
/pwx/informatica/PowerExchange10.2.0/Informatica_PowerExchange10.2.0_HotFix_2.log

Product Name
Informatica PowerExchange 10.2.0 HotFix 2

Press to continue ...
[user@pwxSerever1001]:/pwx/informatica/pwx1020 #