Table of Contents

Search

  1. Introduction to Data Discovery
  2. Data Discovery with Informatica Analyst
  3. Data Discovery with Informatica Developer
  4. Function Support Based on Profiling Warehouse Connection

Data Discovery Guide

Data Discovery Guide

Curating Column Relationships

Curating Column Relationships

You can approve, reject, and reset data relationships in the
Foreign Key Profiling
view.
  1. Open a profile after you run it.
  2. Verify that you are in the
    Foreign Key Profiling
    view.
  3. In the graphical view to reject an inferred column relationship, select the data object, right-click a data object, and select one of the following options:
    • Reject All Relationships with
      Inferred Primary Keys
      . Choose this option to reject all the relationships between the columns with inferred primary keys in the data object to the columns with inferred foreign keys in the other connected data objects.
    • Reject All Relationships with
      Inferred Foreign Keys
      . Choose this option to reject all the relationships between the columns with inferred foreign keys in the data object to the columns with inferred primary keys in the other connected data objects.
    • Reject All Relationships with
      Inferred Primary and Foreign Keys
      . Choose this option to reject all the relationships between the columns with inferred primary keys in the data object to the columns with inferred foreign keys in the other connected data objects, and all the relationships between the columns with inferred foreign keys in the data object to the columns with inferred primary keys in the other connected data objects.
  4. In the graphical view, right-click a data object and select
    View Column Relationships
    .
  5. Select a data object relationship that you want to curate.
  6. To approve the column relationship, right-click and click
    Approve
    .
    The status of the row changes to
    Approved
    .
  7. To restore the inferred status of the column relationship, right-click and click
    Reset
    .
  8. To view the rejected column relationships, right-click one of the rows, and then select
    Show Rejected
    .
  9. To hide the rejected data types, right-click one of the rows and select
    Hide Rejected
    .

0 COMMENTS

We’d like to hear from you!