Data Integration Model Subject
Define and justify what constitutes a duplicate customer.in a database during a merge of two databases.
Expert Answer
It is very essential to remove the duplication of data from their databases to achive their perfect business goals.
Standardize contact data: contact information of a customer is unique and it can be useful to identify the duplication of records.
Before merging of records the administartors should define the level of matching and explain the tolerance level for duplication.It is very important for business to define and explain the outline of what is single record for the organization and its use.
To identify duplicates better to use softwares.once you completed the the above steps i.e standardized data and definde the level of matching its better to use software to rectify the duplicates beased on the defined list.Its very bad to check manuallhy and takes much time.so better to use tool to detect the duplication of records.