Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

waht type of interface is used for testing the data in informatica

0 Answers   CTS, TCS,


The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers   Nationwide,


Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  


how do u tune queries?

1 Answers  


how can i invoke pmcmd in command line prompt

1 Answers  






Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  


what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  


Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  


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

0 Answers   SeeInfoBiz, TCS,


Can we update a target table (without primarykey) by using update strategy transformation?

4 Answers   TCS,


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,


Categories