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 are the fact table & dimensional table in pharmaceutical and hospotal related products???
How to create a non-reusable instance of reusable transformations?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Write the prerequisite tasks to achieve the session partition?
What do you mean by worklet?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Is it possible to create multiple domains on a single Informatica server?
Can we override a native sql query within informatica?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is the meaning of decode in informatica?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the sql query overwrite in source qualifier in informatica
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Which transformation is needed while using the Cobol sources as source definitions?