How to call stored Procedure from Workflow monitor in
Informatica 7.1 version?



How to call stored Procedure from Workflow monitor in Informatica 7.1 version?..

Answer / 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

More Informatica Interview Questions

How union transformation is active ?

2 Answers   Puma,


What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,


Explain about Informatica server process that how it works relates to mapping variables?

0 Answers   Informatica,


1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers   FCS, IBM, Satyam, TCS,


why we use informatica in our project?

2 Answers   TCS,






What are the types of lookup transformation?

0 Answers   Informatica,


How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,


What is confirmed dimension and fact?

7 Answers  


What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,


When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,


how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.

5 Answers   Keane India Ltd,


What you know about transaction control transformation?

0 Answers  


Categories