DELTA_PERCENT comparison

Required Columns

The following data source and reference source columns are required:

• Data. The value from the data source.

  You can use this comparison with vectors and reverse matching. If you want to create vectors to use in the Match Designer, see Make Vector stage in DataStage.

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

Required Parameters

One parameter is required and one parameter is optional.

• Param 1. The maximum percentage difference that can be tolerated. If you specify a value for only the Param 1 parameter, this value is the percentage that can be tolerated for either reference source value greater than data source value or data source value greater than reference source value. If you specified both parameters, the value for the Param 1 parameter is the maximum percentage tolerated for reference source value greater than data source value.
• Param 2. (Optional) The maximum percentage difference that can be tolerated when reference source value is less than data source value.

Example

A one-year difference for an 85 year-old is less significant than a one-year difference for a three year-old, but a 10% difference for each is more meaningful.

Suppose you are comparing age in two files. If you want a tolerance of a 10% difference in the values, specify 10 for the Param 1 parameter. A 1% difference subtracts 1/11 of the weight range (the difference between the agreement weight and disagreement weight) from the agreement weight. A 10% difference subtracts 10/11 of the difference in the weight range.

You would specify 5 for the Param 2 parameter if you want a 5% tolerance when the reference source value is less than the data source value.