How to call stored Procedure from Workflow monitor in
Informatica 7.1 version?



How to call stored Procedure from Workflow monitor in Informatica 7.1 version?..

Answer / kalyan

If the stored procedure id used to do any operations on the
database tables (say Dropping the indexes on the tgt table
or renaming it or truncating it)then call them at the Pre
SQL and Post SQL options at the session properties of the
Target.

Is This Answer Correct ?    12 Yes 5 No

Post New Answer

More Informatica Interview Questions

Whats there in global repository

0 Answers  


How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  


Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,


Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  


any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  


how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,


if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,


Could you explain what is enterprise data warehouse?

0 Answers  


what is session parameters?

1 Answers   Cap Gemini,


What is the different lookup cache(s)?

0 Answers  


What is the Difference between DSS & OLTP?

5 Answers  


Why do we need informatica?

0 Answers  


Categories