I want to run a informatica worklow after complition of
oracle procedure. That procedure is not running through
informatica and can be run at any time in database.
Informatica is in windows environment. Is it possible ? If
yes please explain.

Answer Posted / amarnath

in the pre-session of the target at session level just give
a command like call procedure_name. this will first execute
the stored proc and then the workflow will load the data.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is DR strategy for Informatica project?

708


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

555


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10282


What is workflow manager?

579


Explain the features of connected and unconnected lookup.

549






How to do unit testing in informatica?

729


Differences between connected and unconnected lookup?

610


What do think which one is the better joiner or look up?

733


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

789


Explain the different kinds of facts.

566


what is the size ur source like(file system or database)? how many record daily come u r banking project?

1753


What is an Integration service in Informatica?

708


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

679


can u any challenge your project?

1612


How can you validate all mappings in the repository simultaneously?

762