|
A sales
and marketing database
receives input from many
sources and often in unregulated
formats. It is inevitable
that duplicate records
appear in the database.
While organizations must accept
this, they need to implement processes
to routinely identify
and eliminate these duplicates.
The SmartData Data
Quality controller allows
a user to test the whole database,
or a portion of it
for duplicates. The user
can scan the data for
duplicates, using flexible
criteria on any database
field. For instance, the
user may select duplicate
criteria of the field First Name to be Soundex (sounds similar) and the
City field to be an exact match.
The application will group
the database into sets
of records where this
criteria is met. The sets
can be browsed on the
screen or printed as a
report for offline review.
Sets can easily and quickly
be merged without any
data loss and with proper
audit trails.
|
