Merge Join

Standard SQL joins ..

Workshop - Merge Join

A workshop to illustrate various SQL joins.

In this workshop, we're going to run through the various join types available in the Merge join step.

---

Create a new Transformation

Any one of these actions opens a new Transformation tab for you to begin designing your transformation.

• By clicking File > New > Transformation

• By using the CTRL-N hot key

Merge Join

1. Data Grid

Data grid

The Data grid step allows you to enter a static list of rows in a grid. This is usually done for testing, reference or demo purposes.

Options

• Meta tab: You can specify the field metadata (output specification) of the data

• Data tab: This grid contains the data. Everything is entered in String format so make sure you use the correct format masks in the metadata tab.

1. Drag the Data Grid step onto the canvas.

2. Open the Data Grid properties dialog box.

3. Ensure the following details are configured, as outlined below:

ABCD - Data Grid

Red Blue Yellow - data grid

2. Merge Join

3. RUN