starting a WF

[ProDev]

Hi All,

In my current project, I need something like this ...

"The Work Flow must start after insertion of a record into a particular Oracle table."

How to do this ?

Any clue ....

Thanks

(ps:- I am using INFA ver 6.2, The mappings are using Oracle source & target tables.)

 

[kishleo]

may i know what is the time interval between two inserts into your table? what if you try to insert another record before completing the execution of your workflow(if your workflow starts after inserting the first record)???


Kishore MCDBA

 

[ProDev]

Well, the situation is like this.

Each of my 14 mappings is inserting single row into Oracle table T_Job_Progress. So, on 14th insertion into this table, I need to run my 15th Work Flow.

 

[Sridharan]

While doing the 14th Insertion also create a file with the value in a specified directory and use that file as an Indicator File for the 15th Mapping.

Sri

 

[blom0344]

Perhaps you may devise something through creating a trigger that updates a counter in a temporary table?
On each insert into the target the trigger should update the counter with 1. When the value 14 is reached this value is used to allow the 15th insert.

What is the background to your project? Somehow your requirements seem to be quite puzzling/exotic

T. Blom
Information analyst
tbl@shimano-eu.com

 

[ProDev]

Guys,

The situation is like this ....

We have 14 work flows all togather, shceduled for mid-night every day.
Each of those starts executed whenever it gets corresponding Indiacator file on/after the scheduled time.

Now, we have to do some thing like ths ....

Our 15th Work Flow needs to start automatically, once all of above 14 WFs completes successfully.

My approach was like this ...

Along with all other targets' insertion, each WF is inserting single record to Oracle table T_Job_Progress, when it runs successfully. So, I was trying to trigger the 15th WF once the T_Job_Progress fills up with all the 14 records.

But, I am not geting best solution to this ...


Any clue please ...


Thanks

 

[kishleo]

you can have an extra column jobs status in T_Job_Progress
and set it to some value like "Completed" after completing each wf
so you can start the wf 15 when you have all 14 records in T_Job_Progress set to "Completed"
i dont know how to do it using informatica, i am using DTS for this purpose.

Kishore MCDBA