Using the expression editor
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:
Click on the icon shown in the following screenshot to open the expression editor.
New windows where you can write the function will pop up . From the Functions tab, you can use these functions. Informatica PowerCenter provides all the functions that cater to the need of SQL/Oracle functions, mathematical functions, trigonometric functions, date functions, and so on.
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:Click on Ports in the expression editor, and double-click on
FIRST_NAME
andLAST_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...