Merging 2 partially complete records to generate a complete record?

Question

Hi Folks

I was wondering if it was possible to selectively merge two records in DQS. So merge two partially complete records to generate a more complete "composite" record? 

In the screenshot below, record 2 is the most complete record, but record 1 contains important information (Role = CEO). The best outcome is to take some information from each.

Can DQS do this?

Regards 

Steve 

Answer 1

No it cannot merge and reconcile.

When you do a matching project, DQS does not merge survivor records to make a new records. Obviously that would be a nice to have feature, but it is easier said than done, and there are some complex nuances to make Merge work well to suit business needs.

You could take the full table output from the Matching results which will have the clustered records groups in their similarity clusters, and create a stored procedure in SQL, an SSIS dataflow with a script component, or a custom app to handle each matching cluster as you please. For example, you might decide that you want to fill in the blanks with the most recent value for Role, keep the Latest date in "First year as customer" and Keep the longest data First Name.

Thanks, Jason

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance