Table of Contents


  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  17. Datatype Reference
  18. Configure the Web Browser

Creating User-Defined Functions

Creating User-Defined Functions

You create user-defined functions in the Designer.
The following table shows the properties you configure when you create a user-defined function:
Name of the function. The name must begin with a letter and can contain letters, numbers, and the following special characters:
_ @ $ #
The name cannot exceed 80 characters and cannot contain spaces.
Public if the function is callable from any expression. Private if the function is only callable from another user-defined function.
Description of the function.
Return Type
Datatype of the values the function returns. The Designer determines the datatype when you create a valid function.
Arguments you want to include in the function. Specify the argument name, transformation datatype, precision, and scale to determines the datatype, precision, and scale of the function input values.
Expression that defines the function. Configure syntax in the Expression Editor. Use the arguments you configured for the function. You can also use transformation language functions, custom functions, or other user-defined functions. Follow the PowerCenter transformation language rules and guidelines.
If you enter the syntax in the Expression window, validate the function from the Tools menu.

Updated June 25, 2018