Table of Contents

Search

  1. Preface
  2. Components
  3. Business services
  4. File listeners
  5. Fixed-width file formats
  6. Hierarchical schemas
  7. Intelligent structure models
  8. Mapplets
  9. Saved queries
  10. Shared sequences
  11. User-defined functions

Components

Components

User-defined functions

User-defined functions

User-defined functions are reusable functions that you can use in expressions. Create user-defined functions to build complex expressions using the
Informatica Intelligent Cloud Services
transformation language. User-defined functions use the same syntax and can use the same transformation language components as transformation and field expressions.
You can include a user-defined function in a transformation expression in a mapping or mapplet, in a field expression in a
mapping
task, or in another user-defined function. To use a user-defined function in an expression, you select the user-defined function in the expression editor and enter the required arguments.
You cannot use a user-defined function in an expression in a
synchronization
task. You also cannot use a user-defined function in any transformation in an
elastic mapping
.
To create and use user-defined functions, your organization must have the appropriate license.

Example

You want to remove leading and trailing spaces from a text string such as a name or address. You create a user-defined function called RemoveSpaces that takes a text string as an argument and performs the LTRIM and RTRIM functions. When you configure the user-defined function, you enter the following expression:
LTrim( RTrim(TextString) )
After you create the function, you use it in an Expression transformation to remove leading and trailing spaces from the incoming field, LAST_NAME. The expression field contains the following expression:
:UDF.RemoveSpaces(LAST_NAME)
In the expression, the user-defined function name is prefaced with :UDF. The incoming field LAST_NAME is passed to the function as the argument.


Updated August 03, 2020