Creating User Defined Function in Informatica....

• In Informatica go to Tools ->User-defined Functions..

• Click on New… which is on right hand side of window.
• Fill the fields as shown below.
Public User Defined functions can be called from any transformation expression.
Private User Defined functions can be called only from other User defined functions.

• You can call this UDF using expression editor…