What is dqm in oracle apps r12 : Data Quality Management Tool

What is dqm in oracle apps r12

DQM is the Data Quality Management Tool available in the Oracle apps r12. This Tool was not available earlier in the Oracle 11i. This data tool come with the Oracle TCA (Trading Community architecture) in oracle apps r12. This is the very powerful Data tool which could be integrate with different Oracle Applications Module. This Tools is specifically deigned to increase the standard of Data Quality in Oracle. This Tool provide many mechanisms to enhance the standards of the data with their algorithms and analysis. DQM is not pre installed with Oracle applications , We need to put enabled in Oracle and then integrate with Different Modules as per our Requirment like If we want to enable the DQM in the Suppliers Master , or in Customer Master or in the Employees area so we can implement this any where in the Oracle Application to enhance our data standards.

 

Purpose and Working of DQM in oracle apps

 

As I said this is the Data Quality tool , which helps to increase the Standards in maintaining the Masters. This Tool has mechanism and many algorithms which helps to analyze and search the data in many forms so that it helps to find and search the duplicate records from system. DQM uses its internal Staging tables to validate the data. This First Migrate all the Data from TCA registry to its staged Schema with its own standard or set of methods. The staged schema is a mirror of a portion of the TCA Registry and contains data that transformations have cleansed and standardized. DQM stores the TCA party data in all prospects so that , there should not be an chance of duplication in the system.

 

DQM not only helps to find the Duplicate data but also helps to prevent the Duplication in the Oracle system with many other Data related features.

Searches through the staged schema are actually searches against the interMedia or B-Tree indexes that index the schema and speed up the search process. During the acquisition phase of matching, the indexes quickly limit the number of parties to evaluate for scoring.
You can run programs in DQM to generate or update the staged schema and the indexes. For accurate searches, the staged schema can be automatically synchronized with the TCA Registry when records in the Registry are created or updated through user interfaces or TCA import.

DQM Example to Store the Data in the Staging Schema