Data Quality RuleSTD_2014v1

Duplicate Record Prevention

Ensures no duplicate records exist based on defined business keys.

Owner: Unassigned

Updated: 10/31/2025

Business Rule

Duplicate customer, product, or transaction records cause reporting errors and operational inefficiencies.

Technical Implementation

Implement unique constraints on natural business keys. Use fuzzy matching for customer names and addresses during data entry.

Examples

Good practices vs common violations

Good Examples

Single customer record per unique email or Tax ID

Poor Examples (Violations)

Three records for same customer with slight name variations

Additional Information

Target Industries

All

Status

active

Local Network

DQ Improvements

Data quality dimensions improved by this standard

Uniqueness (Objects)

high

The degree to which objects (of the real world) occur only once as a record in a data file.

Type: prevents

Uniqueness (Records)

high

The degree to which records occur only once in a data file.

Type: prevents

Quick Stats

Related KPIs0

DQ Improvements2

Versionv1

API Access

GET /api/standards/duplicate-record-prevention