IBM Support

DataStage partitioning requirements for Range-lookups

Technote (FAQ)


What are the look-up requirements when doing range-lookups?


When using a range lookup, the "Entire" partition method is required. Use the following steps to set the partition method for the lookup stage:

  1. Double click on the look-up stage
  2. Click on Look-up stage properties (upper left hand icon with the hand through it)
  3. Click on Inputs
  4. Click on Partitioning
  5. Click on the Partition type drop down and select Entire
  6. Click on OK

Document information

More support for: InfoSphere Information Server

Software version: 8.1, 8.5, 8.7, 9.1

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1632433

Modified date: 04 February 2016

Translate this page: