Range Lookup

Summary

Checks that range lookups are correctly configured.

Description

When setting up a range lookup, DataStage will build the lookup table based on the primary key fields but not the range fields. If the range option is enabled on the reference link, this will result in duplicates being ignored and the range lookup won’t work as expected.

This rule will check that range lookups have been configured to allow duplicates on the reference link and prevent unexpected results due to an incorrectly configured stage.

Actions

Ensure range lookups are configured to allow duplicates on the reference link.