Table of Contents

Search

  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
  16. Datatype Reference
  17. 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:
Property
Description
Name
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.
Type
Public if the function is callable from any expression. Private if the function is only callable from another user-defined function.
Description
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
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
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 July 02, 2020