Table of Contents

Search

  1. Preface
  2. Introduction to Data Integration Hub
  3. Catalog
  4. Applications
  5. Topics
  6. Creating Topics
  7. Topic Properties
  8. Publications
  9. Creating Publications
  10. Publication Properties
  11. Subscriptions
  12. Creating Subscriptions
  13. Subscription Properties
  14. Events and Event Monitoring
  15. Dashboard and Reports
  16. Glossary

Operator Guide

Operator Guide

Step 4. Define Joins

Step 4. Define Joins

Pull data from multiple topic tables into a single table by creating a join.
  1. Optionally, create joins for the subscription. To create a join, perform the following actions:
    1. Select the topic tables to join from the
      Select Left Table
      and
      Select Right Table
      lists.
    2. Select the join type from the
      Select Join Type
      list and then enter the join name in the
      Join Name
      field. The name that you assign to the join shows in the
      Field Mapping
      page, where you can map the join to a target table. The new join appears on the
      Join
      page.
    3. Select the column to join from the left table and then select the column to join from the right table. To add more columns to the join click the plus sign and then select the columns to join.
    4. Click
      Create Join
      .
  2. Repeat step 1 to create as many joins as required.
  3. Click
    Next
    .
    The
    Target
    page appears.

0 COMMENTS

We’d like to hear from you!