Task 1. Perform a Join Analysis on Two Data Sources
In this task, you perform a join analysis on the Boston_Customers and LA_Customers data sources to view the join conditions.
1. Select the tutorial folder and click File > New > Profile.
2. Select Enterprise Discovery Profile.
3. Click Next.
4. In the Name field, enter Tutorial_Profile.
5. Click Finish.
The Tutorial_Profile profile appears in the Object Explorer.
6. Drag the Boston_Customers and LA_Customers data sources to the editor on the right.
Tip: Hold down the Shift key to select multiple data objects.
7. Right-click a data object name and select Join Profile.
The New Join Profile wizard appears.
8. In the Name field, enter JoinAnalysis.
9. Verify that Boston_Customers and LA_Customers appear as data objects, and click Next.
10. Verify that the CustomerID column is selected in both data sources.
Scroll down the wizard pane to view the columns in both data sets.
Click Next.
11. Click Add to add join conditions.
The Join Condition dialog box appears.
12. In the Columns section, click Add row.
13. Double-click the first row in the left column and select CustomerID.
14. Double-click the first row in the right column and select CustomerID.
15. Click OK, and click Finish.
16. If the Developer tools prompts you to save the changes, click Yes.
The Developer tool runs the profile.
Note: Do not close the profile. You view the profile results in the next task.