User-defined functions extend the PowerCenter transformation language. You can create and manage userdefined functions with the PowerCenter transformation language in the Designer. You can add them to expressions in the Designer or Workflow Manger to reuse expression logic and build complex expressions. Userdefined functions are available to other users in a repository.
You want to remove leading and trailing spaces from last names. You can create a user-defined function named RemoveSpaces to perform the LTRIM and RTRIM functions. When you configure the user-defined function, you enter the following expression:
LTRIM( RTRIM( name))
After you create the function, you can create the following expression in an Expression transformation to remove leading and trailing spaces from last names:
The user-defined function name is prefaced by :UDF. The port name is LAST_NAME. It is the argument of the expression.
Using The Designer
Working With Sources
Working With Flat Files
Working With Targets
Mapping Parameters And Variables
Working With User-defined Functions
Using The Debugger
Viewing Data Lineage
Managing Business Components
Creating Cubes And Dimensions
Using The Mapping Wizards
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.