DSXchange

Posted: **Thu Mar 31, 2016 12:05 am**

The source is Oracle and this is source for Job A:

col1,col2,Indicator
1,a,J
2,b,J
3,c,H
4,d,H

For first two records (where Indicator=J) I need to trigger 3 jobs A, B and C
and for last two records (where Indicator=H) I need to trigger 2 jobs A and C.

How to do above requirement in job sequence?

Tried below thing:
start_loop activity-->Job A-->job B-->Job C-->end_loop activity

Loop will iterate for 2 times and during first iteration I will identify J records by passing J as parameter and then I will trigger jobs A, B and C.
and during second iteration I will identify H records by passing H as parameter and then I need to trigger Job A and C. How do I skip this job B for H records?

[Note: Example cleaned up considerably due to confusing nomenclature - Andy]

Posted: **Thu Mar 31, 2016 12:18 am**

Code: Select all

JobA   ----->  NestedCondition --->  JobB
                      |                |
                      |                |
                      |                V
                      +-----------> Sequencer  ----->  JobC
                                      (any)

Posted: **Thu Mar 31, 2016 1:18 am**

Use the nested condition in trigger.

Job A - need to run in all case
Job B - need to run when Indicator is J but not when Indicator is H
Job C - need to run in all case

Code: Select all

Loop Start --->Job A ---> If Indicator is J ----> Job B   -------
                          If Indicator is H -----> job C <------|
                                                  |
                                                  |
                                            Loop End

DSXchange

How to skip a job in a sequence based on data?

How to skip a job in a sequence based on data?