If primary key or foreign key information is registered in the metadata for the table
that you drag and drop onto the workspace, then the data builder retrieves the foreign
key and primary key information.
The data builder then iterates over each of the tables that are already in the workspace
in the same sequence in which they were added to the workspace. The data builder
retrieves the foreign key and primary key information for the table, and compares
the length, type, and name with the key columns for the newly added table. If a match
is found, then the tables are used in the join, and the columns are added as a join
condition. The data builder continues to search for matches between the two tables,
and it adds join conditions when possible. After a set of join tables is identified,
the data builder does not continue iterating over the tables that are already in the
workspace.