Toad Data Point 6.1.2

Chat now with support

Create Amazon Redshift Connections Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Create SharePoint Connections Understand Toad Connections Troubleshoot SQL Server Connections

Understand

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Query

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Report

Tutorial: Create a Toad Data Report Manage Reports

About Managing Reports DB2 Reports MySQL Reports ODBC Reports Oracle Reports SQL Server Reports

Publish and Share Reports

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

Analyze Joins

Toad provides a tool to help you analyze and visualize joins. This feature is available in the Query Builder and the Database Diagram (ER Diagram) and allows you to profile data based on the relationship between tables. Use this feature in conjunction with Data Profiling to help you assess data content and quality.

After building a query in the Query Builder or a diagram in Database Diagram, simply click on a join to view a Venn diagram and a data grid. The Venn diagram allows you to visualize how values (rows) are distributed within the joined tables. The data grid displays the data represented by the selected segment of the Venn diagram.

To analyze joins

Build a query in the Query Builder (or a diagram in the Database Diagram).
Add or modify joins, as necessary. See Join Columns for more information.
In your diagram, click on the join you want to analyze.
The Analyze Join pane opens displaying the Venn diagram of the join. Click on a segment of the Venn diagram to display the data represented by that segment.
- Overlapping areas of the Venn diagram represent values common to both tables.
- Exclusive areas of the Venn diagram represent values exclusive to one of the tables.
If the join is a Cartesian join or if it is not a good relationship, this is indicated in the diagram.

Tips:

Click to refresh the diagram or to deselect a segment.
Click to enlarge the Analyze Join window.

Considerations and Limitations of Analyze Join

Consideration/Limitation	Description
Some data sources are not supported	The Analyze Join feature does not support the following data sources at this time: Google Analytics, Salesforce, Oracle BI Enterprise, Microsoft SQL Server Analysis Services, and OData.
Toad Views are not supported	You cannot use Analyze Join with Toad Views.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Toad Data Point 6.1.2 - User Guide

Analyze Joins

Considerations and Limitations of Analyze Join