PRORATED comparison

Compares numeric columns and allows them to disagree by an absolute amount that you specify. Any difference between 0 and the specified amount receives a weight proportionally equal to that difference.

A difference of zero between the two columns results in the full agreement weight being assigned. A difference greater than the absolute amount results in the disagreement weight being assigned. Any difference between zero and the specified absolute amounts receives a weight proportionally equal to the difference.

Required Columns

The following data source and reference source columns are required:

  • Data. The numeric column 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 numeric column from the reference source (only applies for a two-source match).

Required Parameters

The following parameters are required:

Parameter 1 is required, Parameter 2 is optional:

  • Param 1. The maximum absolute value difference that can be tolerated. If you specify only Param 1, that value is the difference 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 specify both parameters, Param 1 is the difference that can be tolerated for reference source value greater than data source value.

  • Param 2. (Optional) The absolute value difference that can be tolerated when reference source value is less than data source value.

Example 1

Small differences between the columns receive slightly less than the full agreement weight. Large differences receive weights closer to the disagreement weight.

Suppose that you specify 15 for Param 1. Suppose the value from the reference source is greater than the value from the data source by a difference of 18. The comparison receives the full disagreement weight. Suppose the value from the reference source is greater than the value from the data source by a difference of 8. In that case, the comparison receives a weight exactly between the agreement and disagreement weight.

Example 2

Suppose you are comparing two dates and specify 5 for Param 1 and 7 for Param 2. The reference source value can exceed the data source value by five days, but the data source value can exceed the reference source value by seven days.