Table of Contents


  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

Adding Match Columns for Exact-match Base Objects

Adding Match Columns for Exact-match Base Objects

You can add only exact-match columns for exact-match base objects. Fuzzy-match columns are not allowed.
To add an exact-match column for an exact-match base object:
  1. In the Schema Manager, navigate to the
    Match Columns
  2. Acquire a write lock.
  3. To add an exact-match column, click the
    The Schema Manager displays the Add Exact-match Column dialog.
  4. Specify the following settings.
    Match Path Component
    Match path component for this exact-match column. For an exact-match column, the source table can be the parent table and / or child physical columns.
    Field Name
    Name of this field as it will be displayed in the
    Hub Console
  5. Specify the base object column(s) for the exact match.
  6. To add a column to the Selected Columns list, select a column name and then click the right arrow.
    • If you add multiple columns, the values are concatenated, with a separator space between values.
    • Concatenating columns is not recommended for exact match columns.
  7. Click
    The Schema Manager adds the selected match column(s) to the Match Columns list.
  8. Click the
    button to save your changes.


We’d like to hear from you!