Transformations receive the data from input ports and send the data out using 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 and 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 that come from input ports and send them using an 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
. We need to add the FULL_NAME
port after LAST_NAME
, because the FULL_NAME
port will use the values in FIRST_NAME
and LAST_NAME
. To add a new port, 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 the proper data type and size of the new ports that are added. As you can see, we have disabled the input ports of FULL_NAME
and TOTAL_SALARY
. Also, as you must have noticed, we have disabled the output ports of FIRST_NAME
, LAST_NAME
, JAN_SALARY
, and FEB_SALARY
as we do not wish to pass the data from those ports to the output. This is as per the coding standards we follow in Informatica.
Once you disable the input ports of FULL_NAME
and TOTAL_SALARY
, you will be able to write the function for the port.