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:
- Double click on the look-up stage
- Click on Look-up stage properties (upper left hand icon with the hand through it)
- Click on Inputs
- Click on Partitioning
- Click on the Partition type drop down and select Entire
- Click on OK