Adjusting the Weights of the RPS Factors
You can change the weight (importance) of the RPS factors using Studio’s configuration parameters. Adjusting the weights affects which relationships and how many relationships are discovered. The five weight percentages ideally add up to 100. However, this is not required, because each weight is calculated according to the following formula: weight = weight percentage / sum of all weights.
The default settings, which apply to non-string data types, are as follows:
Column Name Comparison Factor (40%)
Index Key Factor (30%)
Match Percentage Factor (10%)
Number of Matches Factor (10%)
Schema Locality Factor (10%)
String data types (CHAR, LONGVARCHAR, and VARCHAR) are set so that more weight is given to the data and less to the column name. String factor weight settings, which cannot be modified:
Name Factor (10%)
Relationship Cardinality Factor (30%)
Match Percentage Factor (10%)
Number of Matches Factor (40%)
Locality Factor (10%)
The RPS weights that you can configure as described below apply to non-string data types only.
To change the relationship weight factors
1. In Studio, choose Configuration from the Administration menu.
2. Expand the Discovery and then the Relationship branches.
The current weights for each factor are displayed.
3. Select the weight you want to change and adjust the value. The minimum value is 0; the maximum value is 100. The five weight configuration parameters should ideally add up to 100.
4. Click Apply and then OK to apply your configuration changes.