I want to perform an action after both operations to target1 and target2 is complete which is executed in parallel . Is this possible and could anyone explain how we can do it?
I know my subject is bit absurd but I dont how to articulate this piece of requirement
What type of action, an sql statement?
If so, try 2 possible ways:
- Run an after sql statement in one of the target stages. I believe they end at the same time as the rejection link(to table 2) is only active while there are records being sent to table 1.
- Do it in another job, and link them on a Sequence job.
Last edited by pnpmarques on Fri Sep 21, 2012 9:34 am, edited 1 time in total.
I cannot run an after SQL statement on one target table as other might be still running. I want this to happen only when both the operations are done completely and in the same job
Assuming your job is:
Source ----> Transformer ------> target 1 (target table) ---------> target 2 (reject table)
And that Help says: When the Oracle connector includes a reject link, records that meet specified reject criteria are automatically routed to the target stage on the reject link, and processing continues for the remaining records.
After reading this do you believe that the after-sql statement in either targets may run before any of them finishes completely?