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 can you increase the performance in joiner transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is olap (on-line analytical processing?
What is the reusable transformation?
How to extract sap data using informatica?
Enlist the tasks for which source qualifier transformation is used.
What is aggregator transformation in informatica?
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?
How can we store previous session logs?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Explain the mapping variable usage example in informatica
How an expression transformation differs from aggregator transformation?
Why update strategy and union transformations are active? Explain with examples.
What is a snowflake schema?
What is the command used to run a batch?