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

How you can differentiate between connected lookup and unconnected lookup?

613


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1533


What is Cognos script editor?

3788


How might one distinguish in the case of mapping is right or not without associating session?

641


What is an expression transformation?

594






What is the difference between writing a joiner query in ANSI style and THETA style?

1921


How to load the data from a flat file into the target where the source flat file name changes daily?

575


What are the limitations of joiner transformation?

655


Explain sessions and how many types of sessions are there?

584


Describe an informatica powercenter?

609


What is a joiner transformation and why it is an active one?

580


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1776


Slowly changing dimensions, types and where will you use them

1274


Write the prerequisite tasks to achieve the session partition?

650


What do you understand by a term domain?

670