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 |
waht type of interface is used for testing the data in informatica
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Can yoU use the maping parameters or variables created in one maping into another maping?
how do u tune queries?
how can i invoke pmcmd in command line prompt
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
what is the diff b/w target load plan and cbl?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
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
Can we update a target table (without primarykey) by using update strategy transformation?
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 ?