User function in ODI

•  User functions are used to create user define functions which we can use
  in Mapping or in procedures.
• We used it into mapping to perform some complex transformation or operation.
• User functions improve code sharing and re-usability and facilitate the maintenance and the portability of your developments across different target platforms.
• User functions are implemented in one or more technologies and can be used anywhere in mappings, joins, filters

Create function to implement Functionality OF NVL function

step 2: Give proper name of User function
Define group for User function
Define syntax for user function and define argument for it.

step 3: Select technology and define implementation syntax

step 4: Right click on target data store and Create target data store

step 5: Define target data store Attribute

step 6: Create mapping

step 7: Define mapping name

step 8: source: Employees
Target: New NVL function data store

step 9: Click on user function and select attribute and pass it into function

step 10: Define integration type

step 11: Select IKM

step 12: Validating mapping

step 13: Run mapping and See Session in operator

step 14: Right click on target and select data to view target data

step 15: See Target table data