Data Discovery Guide

10.4.0
- 10.5.7
- 10.5.6
- 10.5.2
- 10.5.1
- 10.5

Back Next

Creating a Join Profile

You can analyze potential joins between data objects in an enterprise discovery profile. The join profile stores the analysis in the Model repository.

Create or open an enterprise discovery profile.

Verify that the enterprise discovery profile contains the data objects that you need.

To add a data object to the join profile, drag it from the

Object Explorer

view to the modeling editor.

Select the data objects to profile.

Right-click the objects and select

Join Profile

The profile wizard opens.

Enter a name for the profile. Optionally, enter a text description of the profile.

Verify that the names of the data objects appear under

Data Objects

in the wizard.

Select or clear the option to

Run profile on finish

Click

Select the data columns to include in the profile, and click

Next.

If required, scroll down the data objects to view all available columns. The profile runs on all columns by default.

Click

Add

The

Join Condition

dialog box appears.

Click

New

to activate the column selection fields.

Select the data objects and columns to validate.

You define a join condition between two columns. You can define multiple join conditions across one or more data objects.

Click

to create the join condition.

Optionally, click

Add

to define additional conditions.

Verify that the Left and Right join columns are prefixed with the correct data object names.

Click

Finish

Join Analysis

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Data Discovery Guide

Data Discovery Guide

Creating a Join Profile

Creating a Join Profile