GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  ETL
Go To First  |  Previous Question  |  Next Question 
 ETL  |  Question 12 of 65    Print  
How do we call shell scripts from informatica?

Answer posted by Staline on 2005-05-27 00:42:44: You can use a Command task to call the shell scripts, in the following ways:  
1. Standalone Command task. You can use a Command task anywhere in the workflow or worklet to run shell commands.  
2. Pre- and post-session shell command. You can call a Command task as the pre- or post-session shell command for a Session task. For more information about specifying pre-session and post-session shell commands



  
Total Answers and Comments: 4 Last Update: November 13, 2006   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
May 27, 2005 00:42:44   #1  
Staline        

RE: How do we call shell scripts from informatica?
You can use a Command task to call the shell scripts in the following ways:
1. Standalone Command task. You can use a Command task anywhere in the workflow or worklet to run shell commands.
2. Pre- and post-session shell command. You can call a Command task as the pre- or post-session shell command for a Session task. For more information about specifying pre-session and post-session shell commands

 
Is this answer useful? Yes | No
January 12, 2006 03:36:39   #2  
sithusithu Member Since: December 2005   Contribution: 161    

RE: How do we call shell scripts from informatica?

There is a task named command task using that you can write or call Shell script DOS commands or BAT files

Enjoy Guys

Cheers

Sithu


 
Is this answer useful? Yes | No
January 17, 2006 01:07:08   #3  
sithusithu Member Since: December 2005   Contribution: 161    

RE: How do we call shell scripts from informatica?

There is a task named command task using that you can write or call Shell script DOS commands or BAT files

Enjoy Guys

Cheers

Sithu


 
Is this answer useful? Yes | No
November 12, 2006 20:46:50   #4  
praveenathota Member Since: November 2006   Contribution: 1    

RE: How do we call shell scripts from informatica?

Hi

There are two ways to do this they are as follows:

1)we can use a command task anywhere in the workflow or worklet to run the shell commands.

2)In the session task we can call reusable command task in the pre-session post_session property to run shell commands.

or

we can write pre-session or post-session commands in the session.

we can use server variables and session variables in the pre and post-session shell commands but not in the standalone command task.

praveena


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape