Range Lookup in Join stage

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
rohithmuthyala
Participant
Posts: 57
Joined: Wed Oct 21, 2009 4:46 am
Location: India

Range Lookup in Join stage

Post by rohithmuthyala »

Hi,

Is it possible to do the range lookup in a join stage..?

Meaning, if the data volume if large then it's not feasible to use a lookup, so how to execute the concept of range lookup in a join stage...!
Rohith
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

It's not possible. The Join stage only performs equi-joins.

Push the join back into the database (if possible) with a BETWEEN operator in the join condition.
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)”