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

Editing Foreign Key Relationships

Editing Foreign Key Relationships

You can change only the Lookup Display Name in a foreign key relationship. To change any other properties, you need to delete the relationship, add it again, and specify the properties you want.
To edit the lookup display name for 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 and right-click
    Relationships
    .
    The Schema Manager displays the Properties tab of the Relationships page.
  4. On the
    Properties
    tab, click the foreign key relationship whose properties you want to view.
    The Schema Manager displays the relationship details.
  5. Click the
    Edit
    button next to the Lookup Display Name and specify the new value.
  6. If you want, select the
    Has Associated Index
    check box to add an index on this foreign key relationship, or clear it to remove an existing index.
  7. Click the
    Save
    button to save your changes.

0 COMMENTS

We’d like to hear from you!