Mostly we work on pre defined environment which Informatica Administrators sets up for us . and we hardly bother to know basics behind it .
Lets say we have installed Informatica Newly and we want to use PMCMD command to start workflow does it work , NO we have to do some basic configurations as follows .
Steps .
1. check whether domains.infa file is present on your system (Server)
2. Mostly you will find in Informatica installation folder .
3. Create Environment variable as below
INFA_DOMAINS_FILE <Path of file >\domains.infa
4.Know your Gateway domain localhost and port and execute following command
Infacmd updateGatewayInfo -dn <gateway domain> -dg <Host>:<Port>
Example :
Infacmd updateGatewayInfo -dn domain_POWEROBJECT -dg POWEROBJECT:6005
You are ready for using PMCMD !!!!!!!
make sure you are having path set for folder holding PMCMD utility else you have to go to the folder where pmcmd is present and fire command from there .
which is not good practice in real scenarions .
PMCMD Command to start workflow
pmcmd startworkflow -sv PowerCenter_Integration_Service
-d Domain_POWEROBJECT
-u Administrator
-p Awani12#
-f First_Run wf_m_nyse_stock_2001_details
Lets say we have installed Informatica Newly and we want to use PMCMD command to start workflow does it work , NO we have to do some basic configurations as follows .
Steps .
1. check whether domains.infa file is present on your system (Server)
2. Mostly you will find in Informatica installation folder .
3. Create Environment variable as below
INFA_DOMAINS_FILE <Path of file >\domains.infa
4.Know your Gateway domain localhost and port and execute following command
Infacmd updateGatewayInfo -dn <gateway domain> -dg <Host>:<Port>
Example :
Infacmd updateGatewayInfo -dn domain_POWEROBJECT -dg POWEROBJECT:6005
You are ready for using PMCMD !!!!!!!
make sure you are having path set for folder holding PMCMD utility else you have to go to the folder where pmcmd is present and fire command from there .
which is not good practice in real scenarions .
PMCMD Command to start workflow
pmcmd startworkflow -sv PowerCenter_Integration_Service
-d Domain_POWEROBJECT
-u Administrator
-p Awani12#
-f First_Run wf_m_nyse_stock_2001_details