1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Can we call a stored procedure from a unix script which is run
using command task

Question Posted / mahee


Can we call a stored procedure from a unix script which is run using command task..

Answer / prabhu

Yes.we can.Use sqlplus -s command in unix to connect to
oracle from unix.Then we can execute the stored proc.

Prabhu
www.iskilltech.com

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,

What is the Router transformation?

2 Answers   Informatica,

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,

What is degenerated dimention table?

7 Answers   Patni,

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,




what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

Can you use one mapping to populate two tables in different schemas

2 Answers  

What do you understand by SOA of Informatica?

0 Answers  

what is the function of 'F10' informatica ?

4 Answers   IBM,

What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

1 Answers   CTS,

How can informatica be used for an organization?

0 Answers  

how can i invoke pmcmd in command line prompt

1 Answers  

For more Informatica Interview Questions Click Here
Categories