TCA and DQM Overview

1
TCA and DQM Overview
Please click to proceed through presentation

• Anil Passi

2
Student System Student Number Same as Party
Number Last Name Referenced from TCA First
Name Referenced from TCA Date Of Birth
Referenced from TCAParty Id
Payables PO_VENDORS Vendor NumberVendor
Name Employee Id
HRMS PER_ALL_PEOPLE_F EMPLOYEE_NUMBERCID LAST_NA
ME FIRST_NAME DATE_OF_BIRTH PERSON_ID Reference
to Party Id
TCA HZ_PARTIES Party Number Last Name First
Name Date Of Birth Gender Reference to Person
Id PARTY_ID
Kept in Synch-In Different physical schemas
3
Purpose of Transformation in DQM?
Staging
First Name Anil
4

• To setup DQM for Staging-
• Decide the columns that you would like to search
  score/rank upon. For example Last Name, First
  Name, DOB, NI Number etc
• Define custom attributes for those columns that
  are not held within TCA table like HZ_PARTIES.
  For example NI Number is not in TCA tables, hence
  we can define Custom Attributes for NI Number,
  and then define Custom Procedure that returns NI
  number from HR tables for a given party_id
• Define the transformations for each column.
  Multiple transformations can be defined

5
Define match rules
6
Scoring Phase After Acquisition phase is
completed
Transformations used in Acquisition can be used
for Scoring too.
7

• Records with Highest score are displayed on the
  Top of DQM Screen

End of presentation - Thanks