Table of Contents

Search

  1. Preface
  2. Introduction
  3. Working with Enterprise Data Manager
  4. Enterprise Data Manager
  5. ILM Repository Constraints
  6. Partition Exchange Purging
  7. APIs
  8. Smart Partitioning
  9. Salesforce Accelerator
  10. SAP Application Retirement Entities
  11. Import Formats for Constraints
  12. Glossary

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Viewing and Importing Suggested Unique Columns

Viewing and Importing Suggested Unique Columns

After you discover table relationships, view the suggested unique columns. Choose the unique columns that you want to import as constraints. When you import the suggested unique columns as constraints, the ILM engine creates the constraints for the related table metadata in the ILM repository.
  1. Click
    File
    View Constraints
    .
  2. In the navigation pane, right-click the application version or the application module that you want to import the suggested unique columns for.
  3. Select
    View Suggested Unique Columns
    .
    A table appears with the suggestions that were identified from the table relationship discovery tool.
  4. Review the suggestions.
  5. If you discovered relationships from ERwin data models or from profile results that were generated from Informatica Developer, you may need to select the parent schema and the child schema from the drop-down box.
    If the table relationship discovery tool cannot identify the schema names, then the table shows an underscore for the schema name.
  6. Select the suggestions that you want to import and click
    Submit.

0 COMMENTS

We’d like to hear from you!