My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.