Lookup Stage Reverse Functionality

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

Post by ray.wurlod »

Set your Lookup Failed rule to Continue. Columns from the reference input will be NULL if the lookup fails. Detect this condition in a downstream Filter or Transformer stage.

But why bother? Just reverse the sense of the "normal" and "reject" output links, and annotate your diagram to alert future developers to the fact that this is how your design works.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”