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).