NUMERIC comparison

Converts two strings to integers and then performs a numeric comparison of the integers. When converting the strings to integers, leading and trailing spaces are ignored.

Required Columns

The following data source and reference source columns are required.

  • Data. Column from the data source.

    You can use this comparison with vectors and reverse matching. To create vectors for use in the Match Designer, see Make Vector stage in DataStage.

  • Reference. Column from the reference source (only applies for a two-source match).