Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8272 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 is event and what are the tasks related to it?
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
any body can say about all versions of informatica ?how many versions ?
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
What is the difference between a repository server and a powerhouse?
What is the procedure for creating independent data marts from informatica 7.1?
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
Discuss the advantages & Disadvantages of star & snowflake schema?
Explain dynamic target flat file name generation in informatica
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Teradata 
