Define input ports for each column in the employee source table. Select

Copy to Output

to change the input ports to pass-through ports for the columns. When you select

Copy to Output

, the Developer tool creates the corresponding output port for each port that you copy.

Create the following input pass-through ports:

The SQL transformation has the following output ports:

The Developer tool adds the "_output" suffix to each output port that it creates when you select

Copy to Output

.

Manually define the output ports for the hire date and salary columns. The SQL transformation returns the hire date and salary columns from the Salary table in the ports.