Join
For details on creating a join, see this video:
Two or more source tables feed data to a single target table in a join relationship with a join condition. Column maps in a join relation may have a 1-to-1 or Many-to-1 relation.
Parent topic: Table transformation types