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

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

Question Posted / mahee

1 Answers
6960 Views
TCS, I also Faced
E-Mail Answers

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

Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers IBM,

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

1 Answers IBM,

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

0 Answers CTS,

how can we load first and last record from a flat file source to target?

7 Answers Infosys, ITC Infotech,

how can we calculate fact table size?

1 Answers

How to update a particular record in target with out running whole workflow?

0 Answers

What is the function of look up transformation?

0 Answers

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

0 Answers

Performance tuning( what you did in performance tuning)