How to call stored Procedure from Workflow monitor in
Informatica 7.1 version?
- 1 Answers
- 19208 Views
- Accenture, I also Faced
- E-Mail Answers
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 load the name of the current processing flat file along with the data into the target using informatica mapping?
In which transformation you cannot drag ports into it?
How will the document be delivered to me?
What is substr in informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Design time, run time. If you don't create parameter what will happen
What is domain and gateway node?
How many dimensions are there in informatica?
How we can use union transformation?
Write the different tools in the workflow manager?
What is a sequence generator transformation?
How can we update a record in the target table without using update strategy?
can u any challenge your project?
I have a flat file, want to reverse the contents of the flat file
What are some examples of informatica etl programs?
