Table of Contents

Search

  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 Foreign Key Relationships

Adding Foreign Key Relationships

You can add a foreign key relationship between two base objects.
  1. Start the Schema Manager.
  2. Acquire a write lock.
  3. In the schema tree, expand a base object (the base object that will be the child in the relationship).
  4. Right-click
    Relationships
    .
    The Schema Manager displays the Properties tab of the Relationships page.
  5. Click the
    Add
    button.
    The Schema Manager displays the Add Relationship dialog.
  6. Define the new relationship by selecting:
    • a column in the Relate from tree, and
    • a column in the Relate to tree
  7. If you want, check (select) the
    Create associated index
    check box if you want to create an index on this a foreign key relationship. Metadata is defined in the
    Operational Reference Store
    that an index exists.
  8. Click
    OK.
  9. Click the
    Diagram
    tab to view the foreign key relationship diagram.
  10. Click the
    Save
    button to save your changes.
    After you have created a relationship, if you go back and try to create another relationship, the column is not displayed because it is in use. When you delete the relationship, the column will be displayed.

0 COMMENTS

We’d like to hear from you!