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