implement a scenario in DS

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ag_ram
Premium Member
Premium Member
Posts: 524
Joined: Wed Feb 28, 2007 3:51 am

implement a scenario in DS

Post by ag_ram »

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 :?:
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply