Friday, October 30, 2020

User Functions in ODI 12c

User functions can be used for reducing the complexity of code in mapping/procedures.

To avoid redundancy in mappings.
Re-usability and sharing code to other mappings

We can used in:

·         mapping

·         Procedure

·         Expressions

·         Filter component

·         Joiner component

Source table:

Here we have to create trim user function for all mapping,that is for project level.


·         Create source table and target tables same as above

·         Refresh the models using reverse engineering KMs

·         Follow the below steps to create user functions.

·         create user function in project


Enter the Name and group name of user functions

Enter the syntax which is function


Go to implementation tab and select add button (+)

Select the technology and logic with parameters.


Create Mapping for execute our function

Here we are using expression transformation

We must use trim user function on FIRST_NAME

Logic in expression component.

·         Use default IKM and LKM

·         Let’s EXECUTE



  1. Wow it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot. If anyone want to grow your Skills with Software Testing So Can Contact Here-+91-9311002620 Or Visit Website-

  2. This site helps to clear your all query. Shekhawati University time table 2021
    allahabad university exam time table 2021 This is really worth reading. nice informative article.

  3. product is awesome.. value for monry feeling lucky to by this product I like this product I
    really like

    click for info

  4. The blogs you have posted have taught you lot of good things Thanks for sharing.
    read more

  5. Very good information given on his new blogs and famous and trendy blogs with different categories.
    Read the article

  6. Finally, I found your blog very informative blog. Great content; you explain every point very clearly. If someone is looking to hire a developer to develop a website or app, this blog helps them. Please post more content like this. Thanks for posting this.
    web design company in USA

  7. Your blog is excellent, and you have provided very important information through this blog. I was looking for a similar blog for a long time that can clear my doubts. That's why I want to thank you, and I wish you to keep writing similar blogs in the future. Apart from this, if you ever need a Automated Software Testing service Company then you can get all the information on this website.

    Have a nice day!
    Keep it up.

  8. IT sourcing and business to identify the documents of all SAAS app and subscription throughout the organization
    SAAS is an aspect of cloud computing that emerge as internet has to become decentralized and accessible with high
    speed. SAAS means new enterprise and niche base application.
    Midnight Marketing service will help you to send and receive SMS with communication channels you use to connect
    with your audience. Software as a service

  9. SLA Jobs is offering the best Software Testing Training in Chennai to provide in-depth understanding and hands-on exposure for testing and verifying software products or applications that are developed by top companies. Gain expertise in manual testing and automation testing through popular tools like Selenium in our Software Testing Training Institute in Chennai.

    Software Testing Training in Chennai

  10. The Website is so easy to use – I am impressed with it. Thank you for Sharing. Azure Developer Course has been designed for software developers who are keen on developing best-in-class applications using this open and advanced platform of Windows Azure.

  11. Thanks for sharing this amazing article. You can also check this: r training course