Working With User-defined Functions overview - Informatica

User-defined functions extend the PowerCenter transformation language. You can create and manage userdefined functions with the PowerCenter transformation language in the Designer. You can add them to expressions in the Designer or Workflow Manger to reuse expression logic and build complex expressions. Userdefined functions are available to other users in a repository.

Example

You want to remove leading and trailing spaces from last names. You can create a user-defined function named RemoveSpaces to perform the LTRIM and RTRIM functions. When you configure the user-defined function, you enter the following expression:

LTRIM( RTRIM( name))

After you create the function, you can create the following expression in an Expression transformation to remove leading and trailing spaces from last names:

:UDF.REMOVESPACES(LAST_NAME)

The user-defined function name is prefaced by :UDF. The port name is LAST_NAME. It is the argument of the expression.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Informatica Topics