Data Warehousing Community Forum
February 08, 2012, 11:50:07 pm

Pages: [1]   Go Down
  Print  
Author Topic: can I have example of shell script?  (Read 4160 times)
london_wannable
DW Fresher
*

Reputation: +1/-0
Offline Offline

Posts: 4


View Profile
« on: November 02, 2007, 09:24:06 pm »


In order to execute the scripts in unix , we need to go for shell scripting.

shell script used for informatica? Example
Logged
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« Reply #1 on: November 05, 2007, 02:26:42 pm »

shell script used for informatica? Example
@London_Wannable,

You mean to say how to run a Unix Shell Script through Informatica Jobs.
Please let us know to provide you a valid information.
Logged

london_wannable
DW Fresher
*

Reputation: +1/-0
Offline Offline

Posts: 4


View Profile
« Reply #2 on: November 06, 2007, 07:31:22 pm »

yes, how to run a script and a sample script(some script).
Logged
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« Reply #3 on: November 07, 2007, 10:26:04 am »

how to run a script and a sample script(some script).

@london_wannable -

To Run a shell script through Informatica, Just use the Pre/Post-Session command (on Success / on Failure) at session level properties.

In that Pre/Post-Session command, locate the path of the script with the filename.
Based on Pre/Post-Sessioncommand, the Shell script will be called and executed.

A Sample script is as follows -
Summary - Execute a shell script to remove the trigger file before executing the session.

u06/home/pwcenter/bin/delete_trigger.sh

Content of delete_trigger.sh

rm u06/home/pwcenter/sessfiles/trg_dwjob.trg
exit


In Pre-Session command of the session property, use the above command to remove.

It can be achieved in other way also -

In Workflow Manager, we are having a command task. Locate the path of the script with the filename and use this command task before the execution of that particular session.

Let me know, if you need any further info..!

Admin -
Topic Moved from Unix Shell scripting to the appropriate Forum (Informatica)
« Last Edit: November 07, 2007, 05:11:42 pm by Sipra » Logged

Pages: [1]   Go Up
  Print  
 
Jump to: