Chapter 5

• What is the difference between a lookup join, an inner join, and a full join?

The following list highlights the key differences between these joins:

• The lookup source on the right is the User object, and the left data stream is the recipe dataset. Any user record that matches the user ID in the recipe dataset will return information relating to the user and augment it to the recipe dataset without adding any rows.
• The inner join is used to create the intersection, or overlap, of two data sources, where only rows that match both data streams are included.
• A full join is used when you want to include a record for every combination.

• Give one real-world example of how to use a full join.

You want to combine products and product families and cater to every viable combination.

• Why would you need to connect data from external sources with Salesforce objects? Give one practical example.

You want to connect order data...