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.
- 3 Answers
- 6917 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / asha
Oracle proc can create a 0 byte file at the end of the proc
and infa workflow can wait for the file (indicator file) to
begin the execution.
| Is This Answer Correct ? | 2 Yes | 0 No |
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
task is running successfully but data is not loded why?
How to handle changing source file counts in a mapping?
What are the prerequisite tasks to achieve the session partition?
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
What is informatica?
What is the use of code page?
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
What are the limitations of joiner transformation?
What the difference is between a database, a data warehouse and a data mart?
how can import the data from the flat files?
Teradata 
