MDM | technoguru

MDM Match Table Queries :

1. This query provides details about how to get count of automerged record from HMRG Table. Here, automerge_ind=1 means record which are automerged. If we use automerge_ind=0 then it will return manually merge records. -

select count(*) from TCR_HUB1.C_BO_PRTY_hmrg where automerge_ind=1;

2. This query gives count of records with fuzzy or exact match rule.

select count(*) from TCR_HUB1.C_BO_PRTY_hmrg where rowid_match_rule in (

select rowid_match_rule from TCR_HUB1.c_Repos_match_rule where rule_no in (<We can get rule number from C_REPOS_MATCH_RULE table or MDM Hub, e.g. 1, 2, 3 >) );