D_INT comparison

Compares a numeric string from a data source to two numeric intervals from a reference source. You can use this comparison to compare house numbers with census, Etak, GDT DynaMap, or postal code files.

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. A column from the data source that contains numeric values.
  • Reference. The reference column that contains the beginning value of the first interval (such as the left side of the street) from the reference source.
  • Reference. The reference column that contains the ending value of the first interval from the reference source.
  • Reference. The reference column that contains the beginning value of the second interval (such as the right side of the street) from the reference source.
  • Reference. The reference column that contains the ending value of the second interval from the reference source.

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.