DSXchange

Hey Folks
Ran into an implementation that has requirement as follows

2 DataSets to be looked up against each other

2 Conditions

a) Reference link is empty
Pass all records from Stream link (no look-up)
b) Reference is not empty
Match records and pass the matched rows

How it is implemnted now is using a Job-sequence (get # of rows in DS using a shellscript ) use it to branch .

Curious if this can be done at a Job level , than at sequence level

At a job level pass the row count as a job parameter and use its value to drive a conditional lookup in a Lookup stage.

At a sequence level use the row count to select which of two jobs to run - one doesn't even have a Lookup stage.