title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Configure threshold values for cleansing and matching |
Learn how to configure threshold values that will be used during the computer-assisted cleansing and matching activities in SQL Server Data Quality Services (DQS). |
swinarko |
sawinark |
03/01/2017 |
sql |
data-quality-services |
conceptual |
|
|
[!INCLUDE SQL Server - Windows only ASDBMI]
This topic describes how to configure threshold values that will be used during the computer-assisted cleansing and matching activities in [!INCLUDEssDQSnoversion] (DQS).
You must have the dqs_administrator role on the DQS_MAIN database to configure these threshold values.
-
[!INCLUDEssDQSInitialStep] Run the Data Quality Client Application.
-
In the [!INCLUDEssDQSClient] home screen, click Configuration.
-
Next, click the General Settings tab. This tab enables you to specify threshold values for cleansing as well as matching activities.
-
To specify threshold values for the cleansing activity, specify appropriate values in the following boxes under the Interactive Cleansing area:
-
Min score for suggestions: The minimum score or the confidence level that will be used by DQS for suggesting replacements for a value during the computer-assisted cleansing process. Enter a value in the decimal notation of the corresponding percentage value. For example, type 0.75 for 75%. This value should be less than or equal to the value specified in the Min score for auto corrections box. The default value is 0.7.
-
Min score for auto corrections: The minimum score or the confidence level that will be used by DQS for automatically correcting a value during the computer-assisted cleansing process. Enter a value in the decimal notation of the corresponding percentage value. For example, enter 0.9 for 90%. The default value is 0.8.
-
-
To specify threshold value for the matching activity, specify a value in the Min record score box under the Matching area. This value signifies the minimum score for a record to be considered as a match for another record. The default value is 80%.
-
Click Close.