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
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is mapplet in informatica?
To import the flat file definition into the designer where should the flat file be placed?
How to extract the informatica rejected data?
What are the new features of informatica 9.x in developer level?
What is a predefined event?
What do you understand by a term domain?
What is meant by a domain?
What is a sequence generator transformation?
What is the status code in stored procedure transformation?
Explain target update override in informatica
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the types of caches in lookup? Explain them.
What is decode in static cache?