In this section, we will discuss useful functions and features that will help us while we are building our Data Foundation. First, we will cover the features that we can access using the Data Foundation toolbar, which is shown in the following screenshot:
Detect Joins is a nice feature that can be used in the following two cases:
Database Keys: If your reference (foreign) keys are defined on the database level
Column Names: If your database columns follow a standard naming convention
The Detect Joins feature can save a lot of time and effort if you have the data access layer with naming standards and well-defined database keys. Let's try to use the Detect Joins feature to create the remaining joins between tables already inserted in NorthWind
Data Foundation with the following steps: