The Join Condition report provides information about the conditions on which the table or spool relations are joined. Only the steps where a join is performed are displayed.
Example of a Join Condition Report
The following table describes the Join Condition report.
|Step||Specific step in the compare plan.|
|Join Kind||Kind of join performed. For example, Inner, Left Outer, Right Outer, or Full Outer join.|
|Join Type||Type of join performed by Teradata Database (see Join-Method Icons).|
|Join Condition||Condition applied to join the table/spool relations.|