Managing User-Defined Functions - Informatica

You can perform the following tasks to manage user-defined functions:

  • Edit a user-defined function.
  • Validate a user-defined function.
  • View properties of a user-defined function.
  • View user-defined function dependencies.
  • Export a user-defined function.
  • Manage versioning for a user-defined function.

The following table describes the user-defined function management tasks and lists where you can perform each task:

Creating User Defined Functions

Editing User-Defined Functions

You can edit a user-defined function to change the function properties. The changes propagate to all user-defined functions and expressions that use the function.

Use the following rules and guidelines when you edit a user-defined function:

  • If you change the user-defined function name, the Designer does not propagate the name change to expressions within the object. Mappings and workflows that use an expression with the user-defined function may be invalid.
  • If you change the expression of a user-defined function, the Designer may change the datatype of the values the function returns when used in an expression.
  • You cannot change a user-defined function from public to private.
  • If a user-defined function is invalid, mappings and workflows that use the user-defined function may also be invalid. Validate the mappings or workflows.

Deleting User-Defined Functions

When you delete a user-defined function, the Repository Service deletes the function from other user-defined functions and expressions that use it. As a result, these user-defined functions and expressions may be invalid.

Mappings and workflows that use the user-defined function or an expression with the user-defined function may also be invalid. Validate the mappings or workflows.

Exporting User-Defined Functions

You can export a user-defined function to XML. You can then import it into other repositories or repository folders.
If you export a mapping or workflow with a user-defined function, the PowerCenter Client exports the user-defined function.

Validating User-Defined Functions

You can validate a user-defined function from the following areas:

  • Expression Editor when you create or edit a user-defined function
  • Tools menu
  • Query Results window
  • View History window

When you validate a user-defined function, the PowerCenter Client does not validate other user-defined functions and expressions that use the function. If a user-defined function is invalid, any user-defined function and expression that uses the function is also invalid. Similarly, mappings and workflows that use the user-defined function are invalid.

Copying and Deploying User-Defined Functions

When you copy an object that contains a user-defined function, the Copy Wizard also copies the user-defined function. When you deploy a static deployment group that contains user-defined functions, the Copy Wizard also copies the functions. When you deploy a dynamic deployment group that contains user-defined functions, the Copy Wizard does not deploy the functions that are not included in an expression.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Informatica Topics