Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions
  8. Creating Custom Functions
  9. Custom Function API Reference

Transformation Language Reference

Transformation Language Reference

The FUNCTION Element

The FUNCTION Element

Use the FUNCTION element to define properties of the custom function.
The following table shows the attributes of the FUNCTION element:
Attribute
Required/
Optional
Description
NAME
Required
Name of the third-party function that you want to define.
ID
Required
ID for FUNCTION element. Identifies the function.
Get a function ID from Informatica if you are developing custom functions to distribute outside your organization. For more information, see Step 1. Get Repository ID Attributes.
FUNCTION_CATEGORY
Optional
Category of the function you want to define. Use one of the following categories:
  • Character
  • Conversion
  • Data Cleaning
  • Date
  • Numerical
  • Scientific
  • Special
  • Test
The Expression Editor displays the custom function under this category.