To manipulate the date, we need to write the functions in the ports. You can use the functions provided from the list of functions inside the expression editor:
In our scenario, we need to use the CONCAT
function. Double-click on the Concat function under the list of functions to get the function in the editor, as shown in the following screenshot:
FIRST_NAME
and LAST_NAME
to get the function, as shown in the following screenshot:As you can see in the preceding screenshot, the expression editor provides Numeric keypad and Operator keypad, which can be used to write the functions.
Once you finish writing the function, click on Validate to make sure the function is correct syntactically. Then, click on OK.
Similarly, write the function to calculate TOTAL_SALARY
; the function will be JAN_SAL+FEB_SAL
.
Save the mapping to save the metadata in the repository. With this, we are done creating the mapping using the Expression transformation. We have also learned about ports and how to use an expression editor. We discovered how to write functions in a transformation. These details will be used across all other transformations in Informatica.