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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is mean by complex business rule ?

1727


What is a repository? And how to add it in an informatica client?

676


Differentiate between Load Manager and DTM?

1685


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1476


What are the settings that you use to configure the joiner transformation?

622






Define the various join types of joiner transformation?

567


Can anyone tell me the new features in Informatica 9 Version?

1534


Explain constraint based loading in informatica

667


What are active and passive transformations?

658


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

630


Why filter transformation is an active one?

575


 Informatica Checkpoints

2869


What is workflow? What are the components of workflow manager?

718


What is xml source qualifier transformation in informatica?

722


How can we improve session performance in aggregator transformation?

682