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
- 6913 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 |
What are the issues you have faced in your project? How did you overcome those issues?
What is dimensional table? Explain the different dimensions.
what are the transformations that restricts the partitioning of sessions?
what is the incremental agrrigation?
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.
What are the types of maping in Getting Started Wizard?
whats the logic to load the lower level of granularity of data to fact table.
How to retrieve last two days updated records?
After we make a folder shared can it be reversed?Why?
Differentiate between a repository server and a powerhouse?
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
What is the difference between informatica 7.0 and 8.0?
Teradata 
