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
What are the settings that you use to configure the joiner transformation?
What are mapplets? How is it different from a Reusable Transformation?
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??
What is a filter transformation?
How many ways are there to create ports?
Whats there in global repository
Under which circumstances, informatica server creates reject files?
What is deployment group?
what is SDLC way of code development?
How to load last n records of file into target table - informatica
what is mean by complex business rule ?
Explain the shared cache and re-cache?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is data transformation manager process?
How can you increase the performance in joiner transformation?