Is it possible to merge multiple records that are already at the UCM base table? (Doc ID 1608376.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Data Quality - Version 8.1.1.10 [23021] and later
Siebel CRM - Version 8.1.1.10 [23021] and later
Information in this document applies to any platform.

Goal

Depending on how UCM was implemented, some customers may find themselves with several records at the UCM base table that could be considered matches.

E.g.: Suppose Contacts C1 and C2 get added to the base table. Since at that time they were very differente, they were not considered matches. Now, suppose that over time they get changed and become very much alike in such a way that they would be considered matches.

In the above case, how to merge those now matching records since they are already at the base table? Is there a way to find and merge them automatically?

NOTE: This situation could be avoided if a deduplication process was setup to run on the record update. In that case the matches would be found as soon as the records were changed in such a way that they would be considered a possible match.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms