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).