In this article I will touch base upon the data quality management feature of TCA. This article also contains a link to a DQM presentation that will compliment the Q & A in this article. A combination of this article and thepowerpoint presentation should help you understand the basics of DQM [ Data Quality Management ] in Oracle TCA. Is DQM a part of TCA? Yes it is, the setup can be done using responsibility named 'Trading Community Manager'. What are the setup steps for DQM?
DQM setup - Download. SITES_T1 does not exist Error syncing hz_stage_contact_t1:ORA-20000: Oracle Text. DQM Staging Program Run dqm staging program. DQM Staging Program TCA Staged Schema. 41 © 2009 KBACE Technologies, Inc. De-duplicate Dirty Data Now and Forever Using Oracle Data Quality Management.
Note: These steps will get clearer once you finish reading this article + PowerPoint Presentation Here are the steps:- 1. Carlos Santana Songs Mp3. Identify the Attributes that you wish to use for Search and Scoring. Define custom attributes for those columns on which you would like to either search or score, but those columns are not in TCA tables. Assign transformation to each column. Define custom transformation rules if need be, by using PL/SQL 4.
Decide which transformed values are used for Searching and which transformed values are to be used for [both] Searching and/or just Scoring The attribute transformations that you wish to search upon, will have 'Acquisition' checkbox set to Yes. Define your match rules. You can define as many match rules 6.
In Match rules, you specify how the users search criteria[values being used by users] are transformed prior to acquisition. Define scoring/ranking rules 8.
Run the staging process. Give me some examples where DQM is used? Lets say your organization has 50000 employees and a person named john smith gets recruited for a job. HRMS team must know whether this John Smith has had any kind of interaction with the organization in past. Ideally if John Smith has had any kind of interaction with the company in past, then there must exist an entry for this record in TCA. In this case, HR must ensure that HRMS record can be made to point to existing TCA record.
By doing so a 360 degree view of the employee be maintained in your organization. So DQM is about being able to identify a duplicate entry in your system. Correct, and this I made possible by applying some transformations as you will see in the presentation. Is DQM only applicable at party level in TCA? No way, DQM can be made to work at party address level & contact level too.