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: Glossary

Selecting Additional Tables

Selecting Additional Tables

When you created the generic query, you selected the primary table that you want to query. When you edit the query, you can add additional tables. You can also define foreign key relationships between the tables.
If you intend to use a query with an update package, do not select additional tables. The purpose of an update package is to update the data in the primary table.
  1. In the properties pane, click the
    Tables
    tab.
  2. Click the
    Add
    icon.
    If the Add icon is not available, the query is associated with an update package. Update packages can reference only one table.
  3. In the
    Select table to add
    dialog box, select the table and click
    OK
    .
    The table appears in the view area and in the list. In the list, the Join Type is Cross.
  4. Optionally, create a foreign key relationship between the tables:
    1. In the view area, find the columns that you want to relate. The columns must be compatible for a join.
    2. From a circle beside one column, drag a connector line to a circle beside the other column.
      In the list, the Join Type changes to Inner.
    3. Optionally, change the Join Type by selecting a type from the list.
      When a query contains more than one relationship, only one of the relationships can be an outer join.
  5. Add other tables as required.
    If you add a table or relationship in error, you can remove it.
    Option
    Description
    Remove a relationship
    In the view area, right-click the connector line, and click
    Delete
    .
    Remove a table
    In the view area, select the table, and click the
    Delete
    icon. You cannot delete the primary table.
  6. Click the
    Save
    icon.

0 COMMENTS

We’d like to hear from you!