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.

Procedure:

·         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

TRIM($(P1))

Go to implementation tab and select add button (+)

Select the technology and logic with parameters.

TRIM($(P1))

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

Result

19 comments:


  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- https://www.htsindia.com/Courses/python/python-training-institute-in-south-delhi

    ReplyDelete
  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.

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

    click for info

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

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

    ReplyDelete
  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

    ReplyDelete
  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.

    Thanks:-)
    Have a nice day!
    Keep it up.

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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.

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

    ReplyDelete
  12. Ethical Hacking Course in Kolkata Indian Cyber Security Solutions (ICSS) in Kolkata offers an outstanding ethical hacking course designed to turn students into cybersecurity specialists. Participate in hands-on training with real-world scenarios, mastering penetration testing and vulnerability assessment. Join ICSS and become a proficient ethical hacker, ready to confront any cybersecurity challenge with confidence!

    ReplyDelete