PowerCenter
- PowerCenter 10.4.1
- All Products
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. |