Joins

Use the Joins builder to combine data from columns of two physical model tables before it is populated to the logical model columns.

Prerequisites of using joins is:
  • You have at least two physical model tables dragged to the canvas
  • You have defined one or more transformations on the logical table

Example: The Name column in the Product table of your logical model is linked to the Product Name column of Product_A physical table. However, you want to pull in data from another physical table Product_B.

In such a case, you can join the Product Name column of Product_A physical table with the Product Name column of Product_B physical table so that data populated in the logical model is a combination of data between the two physical tables (on the basis of the selected join type).