Mapping Specification Guide

10.5.7
- 10.5.9
- 10.5.8
- 10.5.6
- 10.5
- 10.4.0

Back Next

Mapping Specification Joins

When you use more than one source in a mapping specification, you can select a join type between sources and specify the join criteria. The Analyst tool recommends join conditions for a join between sources. You can also select other join conditions.

After you create and name a join, you can use this join object to join between another join object. You can edit a join to modify the join condition that you specify for a join.

Add a join to add multiple sources to a mapping specification. Edit a join to modify the join condition between the sources.

You can add the following types of join conditions:

Simple join: Uses a single operator in a join condition.

Advanced join: Uses expression functions in the join condition.

When you join between sources, you join the columns from the detail table and the master table.

The following table describes the type of joins:

Join Type	Description
Normal	Discards all rows of data from the master and detail source that do not match, based on the condition.
Master Outer	Keeps all rows of data from the detail source and the matching rows from the master source. Discards the unmatched rows from the master source.
Detail Outer	Keeps all rows of data from the master source and the matching rows from the detail source. Discards the unmatched rows from the detail source.
Full Outer	Keeps all rows of data from both the master and detail sources.

When you create a join between two or more relational tables that have the same column or table names, the Analyst tool uses the table name and column name to create a unique name. For example: TableName.ColumnName.

Mapping Specification Objects

Adding and Editing a Simple Join

Adding an Editing an Advanced Join

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal