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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by lookup transformation? Explain the types of lookup transformation?

571


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

609


How do you set a varible in incremental aggregation

1451


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

629


What is union transformation?

575






How might you approve all mappings in the archive all the while?

602


How many dimensions are there in informatica?

630


What the difference is between a database, a data warehouse and a data mart?

599


tell me 5 session failure in real time how can you solve that in your project?

1634


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5260


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1519


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

609


What is InformaticaPowerCenter?

692


Write the unconnected lookup syntax?

662


What is resilience time?

655