User Defined Functions - Informatica

User Defined Functions - Informatica

Informatica User Defined Functions are similar to Built-in Functions, where these functions need to be created once and execute multiple times

Transformation Logic implemented without User Defined Functions:

Validation “IIF( ISNULL(INPUT),’TRUE’,’FALSE’)” is being performed in multiple ports.

The disadvantage with this approach is any changes to this validation need to be done in all the ports.

This can be addressed by creating a User Defined function and have the logic incorporated there.

Steps to Create User Defined Functions
Step 1 : Right-click on the User-Defined Functions folder in a repository folder in the Designer.
Click on “New”

Step 2: In Editor add the transformation logic / validation that needs to be performed.
Click ok and validate the UDF.