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 / deva
This can be possible with unix . Create a shell scripts
which first has to Execute the stored procedure or Package
and we have command to check the completion or procedure
after that use Pmcmd command in the same unix to start the
workflow.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Parameter and variable differences
How do you use reject loader.
write a query to retrieve the latest records from the table sorted by version(scd)
How are the sources and targets definitions imported in informatica designer?
Make a note of the quantity vaults made in informatica?
How to open an older version of an object in the workspace?
What are the performance considerations when working with aggregator transformation?
How might you approve all mappings in the archive all the while?
What is union transformation?
what is the size of your data warehousing?
Implementation methodology
How we can create indexes after completing the loan process?
What's the layout of parameter file (what does a parameter file contain?)?
What is the difference between informatica 7.0 and 8.0?