How to call stored Procedure from Workflow monitor in
Informatica 7.1 version?
Answer Posted / 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 View All Answers
How to differentiate between the active and passive transformations?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain sessions and how many types of sessions are there?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is workflow manager?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are the static cache and dynamic cache in informatica?
What is mapplet in informatica?
What is xml source qualifier transformation in informatica?
What are the popular informatica products?
What all are steps in up gradation of Informatica server?
How to load data in informatica ?
How to delete duplicate row using informatica?
How to extract the informatica rejected data?
Explian the Process of deployment groups in informatica