Joins
Use the Joins builder to combine data from columns of two physical model tables before it is populated to the logical model columns.
Example: The Name column in the Product table of
your logical model is linked to the Product Name column of the
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 the Product_A physical
table with the Product Name column of the 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).
Note: You need to define one or more
transformations on the logical table before using the Joins builder.
Note: You will be
able to perform joins only if you have at least two physical model tables dragged to the canvas.