Table of Contents

Search

  1. Preface
  2. Introduction to Mapping Specifications
  3. Mapping Specification Configuration
  4. Mapping Specification Objects
  5. Mapping Specification Profiles
  6. Sharing Mapping Specification Logic

Mapping Specification Guide

Mapping Specification Guide

Adding and Editing a Simple Join

Adding and Editing a Simple Join

Add a simple join condition to use a single operator in a join condition. Edit a simple join to modify the join condition between sources.
  1. From the Actions menu, click
    Edit
    Joins
    .
    The
    Edit Mapping Specification
    wizard appears.
  2. On the
    Join
    panel, select one of the following choices:
    • To add a join, click the
      New
      icon.
    • To edit a join, select the join and click the
      Edit
      icon.
    The
    New Join
    or
    Edit Join
    wizard appears.
  3. Enter a name and an optional description.
  4. Select a join type from the
    Join Type
    field.
  5. Select a master data object from the
    Master
    field.
  6. Select a detail data object from the
    Detail
    field.
  7. Select
    Simple Join
    .
  8. Choose to add edit a join condition on the
    Join Condition
    panel.
    • To add a join condition, click the
      New
      icon and select a Master Column Name, Operator, and Detail Column Name.
    • To edit a join condition, modify the
      Master Column Name
      ,
      Operator
      , and
      Detail Column Name
      .
  9. Optionally, click the
    Validate
    icon to validate the join condition.
  10. Optionally, click the
    Refresh
    icon to preview the data.
  11. Click
    OK
    .

0 COMMENTS

We’d like to hear from you!