User function in ODI

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 1:Right click on User function and select new User function

n15

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

new

step 3: Select technology and define implementation syntax

n15

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

n15

step 5: Define target data store Attribute

n15

step 6: Create mapping

n15

step 7: Define mapping name

n15

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

n15

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

n15

step 10: Define integration type

n15

step 11: Select IKM

n15

step 12: Validating mapping

n15

step 13: Run mapping and See Session in operator

n15

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

n15

step 15: See Target table data

n15

Leave a Reply

Your email address will not be published. Required fields are marked *