Pages

Search This Blog

Showing posts with label pmcmd. Show all posts
Showing posts with label pmcmd. Show all posts

Monday, January 23, 2012

[Informatica] How to execute one or more mappings from workflow

There may be scenarios that you need to execute one or more mapping from eniter workflow which may contains number of mappings.

Here is the way of doing that

dos2unix olapjoblist.properties
cd $INFA_HOME/bin/
while read line  
  do
  
   test=$( ./pmcmd starttask -sv $INTEGRATION_SERVICE -d $DOMAIN_NAME -uv INFA_USER -pv INFA_PASS -f $FOLDER_NAME -paramfile $parameterFile -w wf_olapconsolidation -wait $line)
   
  
   if [ "$?" != 0 ]; then
    # handle error
    echo "Summary: Could not execute task."
   else
    # no error
    echo "Summary: Task executed successfully."
   fi
   echo "Error Code:$?"
   echo "Description: $test"
  
done < $currentpath/olapjoblist.properties

so olapjoblist.properties if a file will all the session names with it

Wednesday, December 8, 2010

[Informatica] Powermart Command Prompt pmcmd

Here is the way how you can execute the workflow from command prompt:

./pmcmd
pmcmd> connect -sv TestingRepoIntegrationService1 -d Primatics_corvus.primaticsfinancial.com -u uname -p password
pmcmd> setfolder "Demo Mapping"
pmcmd> startworkflow Main_Model_Bank

---- Description
sv: Integration Service Name
d: Domain Name
u: username
p: password
setfolder: tell the folder name where workflow has been placed
startworkflow : tell the workflow name