Data Quality Management (DQM) in Oracle TCA

Posted by Apurva at 1:57 AM Read our previous post

What is DQM..?

Oracle Trading Community Architecture Data Quality Management (DQM) is a set of tools and features that provide powerful searching and matching functionality for search, duplicate identification, duplicate prevention, and other data management features. With a sophisticated matching mechanism, DQM can determine records that match specified search criteria, or records that are potential duplicates of another record.

The various attributes that are generally used for the duplicate identification are

•          Party

•          Account

•          Address

•          Location

–     Location is a point in geographical space.

–     Normally Part of the address.

•          Contact

•          Contact Point

–     Mode of Contact

•          email

•           phone

Duplicate Identification Process

1. The staged schema stores the transformed TCA Registry attribute values for comparison in the matching process. The included attributes and the transformations applied to each are defined in the ‘Define Attributes and Transformations page’.

2. Input records come in when you enter party information or search criteria.

3. The attributes in the match rule assigned the highest level of uniqueness, as defined in the Define Attributes and Transformations page, are transformed by the transformations ordered first in the match rule based on match precision. This combination represents criteria for the most exact matches. For example, the Address 1 attribute provides a more unique value, across records, than the City attribute. The EXACT transformation, which modifies values less than the CLEANSE transformation, would provide more precise matches based on the transformed values. So Address 1, defined as the most unique attribute for the Address element, is first transformed by EXACT.

4. The attribute values in the input record that are transformed by the transformations in the match rule are compared against the attribute values in the staged schema to determine matches.

5. For each entity, steps 3 through 4 are repeated in sequence of attribute uniqueness and transformation order.

6. When a maximum number of matches is reached, the match results are returned. Search results from the first sequence, with the most exact criteria, would have the highest match percentages.

What does the TCA Data Qquality Management do..?

•          Fuzzy Search

•          Search for parties ,address, contact and contact points.

•          Prevention of Duplicate Entry

•          Bulk Dedupe

•          Identify possible duplicates that exist in the registry.

For the purposes of matching records, DQM takes into account that records can contain typographical errors, spelling errors, or incomplete data. DQM copies the data into staged tables separate from the TCA Registry, and transforms and standardizes the staged records. With fuzzy searches through the transformed data in the staged tables, a set of possible matches in the TCA Registry is established. For resolving duplicates, DQM also lets you define a repository of the entities and procedures that are processed when parties are merged. DQM also provides an Automerge feature to automatically merge records that exceed a specified threshold.


You may also like to read        Territory Management- Defining Service Territory
                                                   Configuring Dashboard in Telesales and Teleservice