Use the following guidelines when you create user-defined functions and use them in Data Validation Option:
User-defined functions are defined in PowerCenter at folder level. They exist in a specific folder in the PowerCenter repository.
You must define a user-defined function in the target folder where Data Validation Option jobs are run so that Data Validation Option can access the function. In the Data Validation Client, you can view the target folder in the list of target repository properties when you edit the PowerCenter repository.
You cannot validate an expression that uses a user-defined function. The Data Validation Client cannot validate user-defined functions that are defined in the PowerCenter repository. If the expression is a valid PowerCenter expression, it will run correctly.
If you validate an expression that uses a user-defined function, the Data Validation Client display an error message similar to the following message: