Learning Informatica PowerCenter 9.x

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:

1. Click on the icon shown in the following screenshot to open the expression editor.
   
2. 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 ...