Join Data

The Join Data command is used to join two data sources into a single result set. You can use one or more columns to join by and can specify the type of join.

Configuration

After you add a Join Data ETL command to the data flow designer and connect two inputs to it, you need to choose the type of join to use. The supported join types are Inner, left, right, or full join. You also need to specify the join column(s) to join on from input tables.

Example

In this example, we joined the data from the sales representative input source with the data from the sales input source using left join on representative name.