The transformations receive the data from the input ports and send the data out using the output ports. Variable ports temporarily store the value while processing the data.
Every transformation with a few exceptions has input and output ports as shown in the following screenshot:
Double-click on the transformation, and click on Ports to open the edit view to see the input, output, and variable ports:
You can disable or enable input or output ports based on the requirement. In our scenario, we need to use the values coming from input port and send it by the output port using concatenate by writing the function in the expression editor.
Create two new output ports for FULL_NAME after LAST_NAME and TOTAL_SALARY after FEB_SALARY. To add new ports, double-click on the expression transformation, click on Ports, and add two new output ports as shown in the following screenshot:
Make sure you define proper data type and size of the new ports added. As you can notice, we have...