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 Primary Key Match Rules

Adding Primary Key Match Rules

To add a new primary key match rule:
  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
    Primary Key Match Rules
    tab.
    The Schema Manager displays the Primary Key Match Rules tab.
    The Primary Key Match Rules tab has the following columns.
    Column
    Description
    Key Combination
    Two source systems for which this primary match key rule will be used for matching. These source systems must already be defined in
    Informatica MDM Hub
    , and staging tables for this base object must be associated with these source systems.
    Auto-Merge
    Specifies whether this primary key match rule results in automatic or manual consolidation.
  4. Click the
    Add
    button to add a primary match key rule.
    The Add Primary Key Match Rule dialog is displayed.
  5. Check (select) the check box next to
    two
    source systems for which you want to match records based on the primary key.
  6. Check (select) the
    Auto-merge matching records
    check box if you are certain that records with identical primary keys are matches.
    You can change your choice for
    Auto-merge matching records
    later, if you want.
  7. Click
    OK
    .
    The Schema Manager displays the new rule in the
    Primary Key Rule
    tab.
  8. Click the
    Save
    button to save your changes.
    The Schema Manager asks you whether you want to reset existing matches.
  9. Choose
    Yes
    to delete all matches currently stored in the match table, if you want.

0 COMMENTS

We’d like to hear from you!