geetham

 Profile Answers by geetham Questions by geetham

• Dec 28th, 2006

 

 Shell Scripts are called through command tasks in a informatica workflow to do the following,

   - To send a startup email after the start of workflow.   - To append date to the flatfile. - To start a informatica mapping thru pmcmd command. -To call a stored procedure through unix. - To check the file count after its been created. -To send target files to mainframe from unix.

Sangeetha.

  

 

vamsi Krishna.k

• Dec 29th, 2006

 

what sangeeta told is right, we can execute shell scripts using command task. Here I'm adding few more points.

1) Shell script can be executed using presession and post session commands at sessions.

2) To execute shell scripts no need to give sh <filename.sh> in presession and post session commands at sessions. But you need to give full path of the shell script.

/unix/informatica/script/example.sh