Using Join Suggestions

Use the Joins builder to combine data from columns of multiple discovered tables before it is populated to the logical model columns.

In Metadata Insights, 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.