INTERVAL_PARITY comparison

Compares a single number from a data source to an interval from a reference source. The odd-even parity of the number must agree with the parity of the beginning value of the interval.

If the number on the data source is odd, the beginning range number from the reference source must also be odd to be considered a match. Similarly, if the number on the data source is even, the beginning range from the reference source must also be even to be considered a match.

This match comparison is used primarily for geocoding applications to compare a house number from the data source to an interval of addresses from the reference source. Reference sources such as ZIP code files have a single odd or even interval. With a parity check, you can specify different intervals for each side of the street.

Frequency information is not taken into account when this match comparison is used but a two-source match requires four input streams. If you use this match comparison with a Two-source Match stage job, create two dummy file inputs instead of files that contain frequency information.

Required Columns

The following data source and reference source columns are required:

  • Data. The number from the data source.
  • Reference. The reference column that contains the beginning value of the interval.
  • Reference. The reference column that contains the ending value of the interval.

Required Mode

A mode is required. Choose one of the following modes:

  • ZERO_VALID. Indicates that a value of 0 in a Data or Reference column is a valid value. A blank value in a Reference column means that the range value that it represents is the same as the range value in the companion Reference column.
  • ZERO_NULL. Indicates that a value of 0 in the Data column is missing data. A value of 0 or a blank value in the Reference column that represents the ending range means that the ending range value is the same as the beginning range value in the Reference column that represents the beginning range.

Example

The beginning value of the interval can be larger than the ending value. For example, if the number from the data source is 153, it matches the interval 199-101 and the interval 101-199.