Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: Configuring Hub Console Tools
  4. Part 3: Building the Data Model
  5. Part 4: Configuring the Data Flow
  6. Part 5: Executing Informatica MDM Hub Processes
  7. Part 6: Configuring Application Access
  8. Appendix A: MDM Hub Properties
  9. Appendix B: Viewing Configuration Details
  10. Appendix C: Row-level Locking
  11. Appendix D: MDM Hub Logging
  12. Appendix E: Table Partitioning
  13. Appendix F: Collecting MDM Environment Information with the Product Usage Toolkit
  14. Appendix G: Glossary

Match Key Tables

Match Key Tables

The match key table contains the match tokens and match keys that the MDM Hub generates for base object records. A match key table is associated with each base object.
The format of match key table names is
C_<base object name>_STRP
. For example, if the name of the base object is PARTY, the name of the associated match key table is C_PARTY_STRP. The tokenize process generates one or more records in the match key table for each record in the base object.
After a match and merge process is complete, the match tokens that are not valid needs to be deleted from the match key table. Also, during retokenization, the match tokens that are not valid are deleted and replaced with valid ones. The operation to delete match tokens that are not valid can affect the performance of the MDM Hub. To improve performance in IBM DB2 environments, configure the
cmx.server.stripDML.useUpdate=true
property that marks the match tokens as not valid instead of deleting them.
The following table describes the important columns in the match key table:
Column Name
Data Type (Size)
Description
ROWID_OBJECT
CHAR (14)
Identifies the record for which the match token was generated.
SSA_KEY
CHAR (8)
Match key for the record. Encoded representation of the value in the fuzzy match key column, such as name, address, or organization name, for the associated base object record. String consists of fixed-length, compressed, and encoded values built from a combination of the words and numbers in a name or address.
SSA_DATA
VARCHAR2 (500)
Non-encoded, plain text, string representation of the concatenated match columns defined in the associated base object record. Concatenated match columns include fuzzy match key as well as all fuzzy match columns and exact match columns.
Each record in the match key table contains a match token, which is the data in both SSA_KEY and SSA_DATA.

0 COMMENTS

We’d like to hear from you!