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 types of lookup transformation?
can anyone explain me about retail domain project in informatica?
What are batches?
4 yrs etl devloper roles and responsibilities?any body give solutions
Write the unconnected lookup syntax?
How many ways are there to do 'remove duplicate records in informatica'?
What can we do to improve the performance of informatica aggregator transformation?
When do you use sql override in a lookup transformation?
What is the difference between stop and abort in informatica
What are the different types of olap? Give an example?
Define filter transformation?
whats the logic to load the lower level of granularity of data to fact table.
What is the function of aggregator transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the advantages of informatica?