IBM Support

DataStage partitioning requirements for Range-lookups

Question & Answer


Question

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

Answer

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

[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1;8.7;8.5;8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21632433