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
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What do you mean by blocking transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to do the error handling of if ur source is flatfiles?
What are the popular informatica products?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is event and what are the tasks related to it?
What is repository manager?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Explain the shared cache and re-cache?
How to load data in informatica ?
What does command task mean?
Global and Local shortcuts. Advantages.
Why update strategy and union transformations are active? Explain with examples.
design of staging area?