Printable View
Hi guyz,
I had an Informatica interview yesterday and I have a moderate experience on the tool (couple of minor projects in past), not any expert.
I was confused on one of the question that I can remember off the top of my head. It'll be great if someone can help me out here.
Q. How to find whether a workflow is successful or not in UNIX?
Appreciate the help !
Thanks,
Saurabh
*bump*
anyone plz?
Hi try this .
============================================================================================
Getworkflowdetails
The getworkflowdetails command returns the folder name, workflow name, last start time, last completion time, workflow status, run mode, and the username that ran the last workflow.
In the command line mode, use the following syntax to get details on a workflow:
pmcmd getworkflowdetails
<-serveraddr|-s> [host:]portno
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<-folder|-f> folder]
workflow
In the interactive mode, enter the following syntax at the pmcmd prompt to get details on a workflow:
getworkflowdetails
[<-folder|-f> folder]
workflow
For information on other parameters used in this command, see Table 23-5.
============================================================================================
Get the path from where informatica is installesd example: C:\Program Files\Informatica PowerCenter 7.1.1\Server\bin\pmcmd
in run command promt get this path or in unix get this path
write the below command to run the workflow
pmcmd startworkflow -s 4001 -u scott -p tiger -f Dev mp_CSV_LOAD_04
pmcmd getworkflowdetails -s 4001 -u scott -p tiger -f Dev mp_CSV_LOAD_04
pmcmd getworkflowdetails -s 4001 -u scott -p tiger -f Test w_s_m_filter
-s serveraddress
-u User
-p password
-f folder
workflow_name