The "UNIQUENESS" rule verifies whether values within a specific data element are unique throughout the dataset.
For instance, if there are duplicate entries for customers in a customer table, it indicates that the data is not unique. This rule detects such duplicates and often displays the duplicate keys along with their count, enabling users to identify and resolve any data duplication issues.
For further information about the rule detail page including scope, threshold, notifications, etc., please see the detailed article Rule Detail page.
Detailed Steps:
Step 1:
Log in to DvSum and proceed to the Data Dictionary tab and select the relevant Data source and Table Name.
Step 2: Select the table name then select the Data Quality tab and choose Available Rules.
Step 3: Select the "⊕ Add Rule" button, then choose the "Foundational DQ" category. From the list of options, click on "UNIQUENESS"
Step 4: Basic Input
In the Rule Wizard's Basic Input section, you need to fill in the Rule Description and Column Name corresponding to the table in which you want to search for Unique records.
Step 5: Validate
After saving the rule, you'll see its definition. Click "Run" to execute and test the rule.
0 Comments