INTERVAL_NOPAR comparison
Compares a single number from a data source to an interval from a reference source. The single number must be within the interval (inclusive of the end points) to be considered a match. The odd-even parity of the single number need not agree with the parity of the beginning value of the interval.
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.