Matching Key Table
The matching key table is created automatically for each Matching step and stores all grouping keys for all instance records, that is, all rules that each instance record satisfied.
The table name structure is described in the following table.
The table prefix is configured in the prefix node in the MDM Configuration file (see MDM Configuration).
Only the VLDB Persistence can be used (see Persistence Layer, section VLDB Persistence).
| Table name | Description |
|---|---|
[prefix][entity_name]_K_K |
The default matching key table. |
[prefix][entity_name]_K_[name] |
The matching key table created for each extra Matching step.
The custom [name] usually refers to a Master Data Layer name, for example, |
Matching Key Table Structure
Below is an extract from a sample matching key table:
| UNI_KEY | INSTANCE_ID | XID | XCTID |
|---|---|---|---|
0:1:81-123 MT PLEASANT RD TORONTO M4W 1N4:204415200000 |
1003 |
2515 |
1002 |
0:3:81-123 MT PLEASANT RD TORONTO M4W 1N4:ID_3213232231 |
1003 |
2516 |
1002 |
0:3:1000 QUEEN STREET EAST TORONTO ONTARIO M4M1K1:ID_3213232231 |
1003 |
2517 |
1002 |
0:1:1000 QUEEN STREET EAST TORONTO ONTARIO M4M1K1:204415200000 |
1003 |
2518 |
1002 |
0:2:EMAIL_JOHN@STARTUP.COM:ID_3213232231:204415200000 |
1003 |
2519 |
1002 |
0:0:163679111 |
1004 |
2527 |
1002 |
0:1:81-123 MT PLEASANT RD TORONTO M4W 1N4:-478141200000 |
1004 |
2528 |
1002 |
0:2:PHONE_+1 (416) 200 4548:ID_7437682322:-478141200000 |
1004 |
2529 |
1002 |
0:2:EMAIL_LUCKYBIRD@HOTMAIL.COM:ID_7437682322:-478141200000 |
1004 |
2530 |
1002 |
0:3:81-123 MT PLEASANT RD TORONTO M4W 1N4:ID_7437682322 |
1004 |
2531 |
1002 |
0:2:CELL_+1 (647) 210 0274:ID_7437682322:-478141200000 |
1004 |
2532 |
1002 |
0:1:11 BLACKWELL CRT LEDUC ALBERTA T9E7L4:682552800000 |
1005 |
2538 |
1002 |
0:3:11 BLACKWELL CRT LEDUC ALBERTA T9E7L4:ID_5907619322 |
1005 |
2539 |
1002 |
0:2:PHONE_+1 648-485-4859:ID_5907619322:682552800000 |
1005 |
2540 |
1002 |
0:2:PHONE_870 204-4567:ID_266805807984498:282610800000 |
1007 |
2555 |
1002 |
0:0:095242434 |
1007 |
2556 |
1002 |
0:2:EMAIL_JOHN.W.SMITH@GMAIL.COM:ID_266805807984498:282610800000 |
1007 |
2557 |
1002 |
0:3:13 GRENADIER HEIGHTS TORONTO ON M6S2W5:ID_266805807984498 |
1007 |
2558 |
1002 |
0:1:13 GRENADIER HEIGHTS TORONTO ON M6S2W5:282610800000 |
1007 |
2559 |
1002 |
0:0:095242434 |
1008 |
2563 |
1002 |
0:1:13 GRENADIER HTS TORONTO ON M6S2W5:282610800000 |
1008 |
2564 |
1002 |
Was this page useful?