What are STRP and MTCH tables in Informatica MDM?

The STRP and MTCH tables are two important tables in Informatica MDM. They are used to store data related to the matching process.

STRP Table

The STRP table stores the SSA_KEYS generated by SSA Name3 for a given record. The keys are used for finding like records from similar keys.

The STRP table is an IOT table in Oracle. This means that it is an index that contains all the data as well. This makes it very efficient for searching the table.

The STRP table contains the following columns:

• SSA_KEY: This is the primary key of the table. It is a unique identifier for each record.
• ROWID_OBJECT: This is the ROWID of the base object record that the SSA_KEY belongs to.
• DATA_ROW: This is the row number of the SSA_DATA column in the STRP record.
• DATA_COUNT: This is the number of rows in the SSA_DATA column.
• SSA_DATA: This is the compressed data for the match columns.

MTCH Table

The MTCH table stores the match results for a given record. The results include the match score, the match path, and the match rules that were used.

The MTCH table is a relational table. This means that it is a table that is made up of rows and columns.

The MTCH table contains the following columns:

• SSA_KEY: This is the primary key of the table. It is a foreign key to the STRP table.
• MATCH_SCORE: This is the score for the match. It is a number that indicates how similar the two records are.
• MATCH_PATH: This is the path that was used to match the two records.
• MATCH_RULES: This is the list of match rules that were used.

How STRP and MTCH Tables Work Together?

The STRP and MTCH tables work together to provide the matching functionality in Informatica MDM. The STRP table is used to find similar records, and the MTCH table is used to store the match results.

When a new record is loaded into Informatica MDM, the STRP table is updated with the SSA_KEY for the new record. The SSA_KEY is then used to search the MTCH table for any existing matches.

If there are any matches, the match results are stored in the MTCH table. The match results can then be used to consolidate the two records.

Conclusion

The STRP and MTCH tables are two important tables in Informatica MDM. They are used to store data related to the matching process. By understanding how these tables work together, you can better understand how the matching functionality in Informatica MDM works.

Learn more about Informatica MDM here