Table of Contents

Search

  1. Preface
  2. Introduction to Data Integration Hub
  3. Getting Started with Data Integration Hub
  4. Creating Topics
  5. Creating Publications
  6. Creating Subscriptions
  7. Appendix A: Glossary

Getting Started

Getting Started

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!