Using Join Suggestions - discovery - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
Topic type
Overview
Reference
How Do I
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552
Use the Joins builder to combine data from columns of multiple discovered tables before it is populated to the logical model columns.

In Spectrum Discovery, if you are using the Discovery module, the Joins page gives you suggestions (Join Suggestion tab). These suggestions are based on the primary and foreign key linkages in the tables you already discovered.

When you accept the suggestion, it displays in the Join Definition tab.

To use Join Suggestions, perform these steps:

  1. On the Create Mapping <logical model name> page, select the required logical entity, and click the Join builder icon on the tool bar . Alternatively, click the Entity Transformation icon of the required logical entity and use the forward arrow on the top right of the page to go to the Join Definition for logical table <table name> page.
  2. Click the Join Suggestion tab.
    The suggestions for joins among the discovered tables mapped to the selected logical model is displayed in the Left table, Right table, and Join type fields.
  3. Select the required suggestion and click Apply Join.
    The join is applied and it becomes visible in the Join Definition tab.
  4. To create another join manually, click the Add table button and see the steps of manual join creation in Creating Join Definitions manually.