Configuration Guide

10.4

Back Next

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.

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Match Key Tables

Match Key Tables