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: Informatica Platform Staging
  15. Appendix H: Informatica Platform Mapping Examples
  16. Appendix I: Glossary

Adding Match Column Rules

Adding Match Column Rules

You can add fuzzy, exact, or filtered match rules.
To add a new exact or fuzzy match rule using match columns:
  1. In the Schema Manager, display the Match/Merge Setup Details dialog for the base object that you want to configure.
  2. Acquire a write lock.
  3. Click the
    Match Rule Sets
    tab.
  4. Select a match rule set in the list.
    The Schema Manager displays the properties for the selected match rule set.
  5. In the Match Rules section of the screen, click the
    Add
    button.
    The Schema Manager displays the Edit Match Rule dialog. This dialog differs slightly between exact match and fuzzy-match base objects.
  6. For fuzzy-match base objects, configure the match rule properties at the top of the dialog box.
  7. Configure the match columns for the match rule.
    1. Click the
      Edit
      button next to the Match Columns list.
      The Add/Remove Match Columns dialog box appears and displays only the match columns that you defined. For exact-match base objects or match rules with an exact match/search strategy, only exact column types are available. For fuzzy-match base objects, you can select fuzzy or exact column types.
    2. Select the fields that you want to add to the match column rule.
    3. Click
      OK
      .
      The Schema Manager displays the selected fields in the Match Columns list.
  8. Configure the match properties for each match column in the Match Columns list.
  9. Click
    OK
    .
  10. If this is an exact match, specify the match properties for this match rule. Click
    OK
    .
  11. Click the
    Save
    button to save your changes.
    Before saving changes, the Schema Manager analyzes the match rule set and prompts you with a message if the match rule set contains any incongruousness.
  12. If you are prompted to confirm saving changes, click
    OK
    button to save your changes.

0 COMMENTS

We’d like to hear from you!