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 as shown in the following screenshot to open the expression editor:
- New windows will pop up where you can write the function. From the
Functionstab, you can use 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
CONCATfunction. Double-click on theConcatfunction under the list of functions to get the function in the editor as shown in the following screenshot:
- Click on
Portsin the expression editor, and double-click onFIRST_NAMEandLAST_NAMEto get the function as shown in the following screenshot:
- As you can notice in the preceding screenshot, the expression editor provides a numeric keypad and an operator keypad...