Table of Contents

Search

  1. Introduction
  2. Configuring Hub Console Tools
  3. Building the Data Model
  4. Configuring the Data Flow
  5. Executing Informatica MDM Hub Processes
  6. Configuring Application Access
  7. MDM Hub Properties
  8. Viewing Configuration Details
  9. Search with Solr
  10. Row-level Locking
  11. MDM Hub Logging
  12. Table Partitioning
  13. Collecting MDM Environment Information with the Product Usage Toolkit
  14. Glossary

Match Subtype

Match Subtype

For base objects containing different types of data, the
match subtype
option allows you to apply match rules to specific types of data within the same base object. You have the option to enable or disable match subtyping for
exact-match column
s that have parent/child path components. Match subtype is available only for:
  • exact-match column types that are based on a non-root Path Component, and
  • match rules that have a fuzzy match / search strategy
To use match subtyping, for each match rule, specify one or more
exact-match column(s)
that will serve as the “subtyping” column(s) to use. The subtype indicator can be set for any of the exact-match columns regardless of whether they are used for segment match or not. During the match process, evaluation of the subtype column precedes evaluation of the other match columns. Use match subtyping judiciously, because it can have a performance impact on the match process.
Match Subtype behaves just like a standard parent/child matching scenario with the additional requirement that the match column marked as Match Subtype must be the same across all records being matched. In the following example, the Match Subtype column is Address Type and the match rule consists of Address Line1, City, and State.
Parent ID
Address Line 1
City
State
Address Type
3
123 Main
NYC
ON
Billing
3
50 John St
Toronto
NY
Shipping
5
123 Main
Toronto
BC
Billing
5
20 Adelaide St
Markham
AB
Shipping
5
50 John St
Ottawa
ON
Billing
7
50 John St
Barrie
BC
Billing
7
20 Adelaide St
Toronto
NB
Shipping
7
90 Yonge St
Toronto
ON
Billing
Without Match Subtype, Parent ID 3 would match with 5 and 7. With Match Subtype, however, Parent ID 3 will not match with 5 nor 7 because the matching rows are distributed between different Address Types. Parent ID 5 and 7 will match with each other, however, because the matching rows all fall within the 'Billing' Address Type.

0 COMMENTS

We’d like to hear from you!