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
What is data caches/ index caches?
design of staging area?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
While migrating the data from one environment to another environment how would you manage the connections?
lookup transformation with screenshots
Please let me know how to make encryption and decryption with example?
How to handle decimal places while importing a flatfile into informatica?
What is lookup transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
what is the size of u r source(like file or table)?
What is sorter transformation?
What is enterprise data warehousing?
Can we change Dynamic to Static or Persistent cache? If so what happens?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the use of an aggregator cache file?