Installation
System Requirements
Install Toad
Specify App Data Directory Location
Install Toad Silently
Install Toad on Citrix Systems
Uninstall Toad
Configure Toad Layouts
Create Connections
Understand Toad Connections
Create Access Connections
Create Amazon Redshift Connections
Create BusinessObjects Connections
Configure DB2 Client Connections
Configure DB2 LDAP Support
Create DB2 Connections
Create Excel Connections
Create SharePoint Connections
Create Google Analytics Connections
Create Hive Connections
Create MySQL Connections
Create ODBC Connections
Configure Oracle LDAP Support
Create Oracle Connections
Create Oracle BI Connections
Create PostgreSQL ODBC Connections
Create Salesforce Connections
Create Snowflake Connections
Create SQL Server Connections
Create SSAS Connections
Create SAP Connections
Create SAP HANA Connection
Create Teradata Connections
Troubleshoot Connections
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.
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. |