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
What are ETL Tools?
In informatica workflow manager, how many repositories can be created?
What is informatica metadata and where is it stored?
What is meant by incremental aggregation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What does cheating measurement mean?
What is target designer and target load order?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is enterprise data warehousing?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are the restrictions of union transformation?
Is there any target staging area in informatica not staging area
How might one distinguish in the case of mapping is right or not without associating session?