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
- 8171 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 |
in which situations do u go for sequence generator ?
What is diff joiner and lookup
What is data merging,data cleansing,sampling?
What is Collect performance data in informatica and what is the use of it.
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are Target Options on the Servers?
What are the reusable transforamtions?
what is upstream and downstream transformation?
What is use of batch file in informatica? How many types of batch file in informatica?
In target table how to display the system time
how do the project develops? pls specify right from the start to end in step by steps.
Teradata 
