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

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,


Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,


What are the different options used to configure the sequential batches?

2 Answers   Wipro,


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

2 Answers  


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  


How many number of sessions that u can create in a batch?

3 Answers  


Kimball and Inmon methodologies?

2 Answers  


What happens when a session fails and you click on recover?

0 Answers  


how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,


Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  


How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,


What is exclusive and normal mode for repository services?

0 Answers  


Categories