Friday, June 24, 2011

Unconnected Lookup Transformation -- Returning Multiple Values

> We can achieve Multiple values from Unconnected Lookup-Tr. We just need to override the default lookup sql query, there in one of the return port we can concatnate the values using ||.

> The concatnated multiple values will be returned from lookup to calling expression. In the expression we can extract / separate the concatnated string value (multiple values concatnated in lookup) and can pass to the target…

SELECT DEPT.DNAME||' '||DEPT.LOC as OUT_MUL_Values, DEPT.DNAME as DNAME, DEPT.LOC as LOC, DEPT.DEPTNO as DEPTNO FROM DEPT

> Before overrideing we should create one return port in the lookup-tr (here OUT_MUL_Values )

> Devide that OUT_MUL_Values in an expression

O_DNAME =     REG_EXTRACT(OUT_MUL_Values,'(\w+)\s+(\w+)',1)
O_LOC  =           REG_EXTRACT(OUT_MUL_Values,'(\w+)\s+(\w+)',2)

> Connect to target...

So here we are getting Multiple values using Unconnected Tr.


19 comments:

  1. Hi ,

    Following is the scenario:-

    I have a control table which consists of the valid values of each column of the source table.

    Now, using a lookup, i need to chk if the value entered by the user is among those in this table.

    Is it possible?

    Regards,
    Jaya

    ReplyDelete
    Replies
    1. I have read your blog its very attractive and impressive. I like it your blog.

      Java Online Training Java EE Online Training Java EE Online Training Java 8 online training Core Java 8 online training

      Java Online Training from India Java Online Training from India Java Online Training

      Delete
  2. Informatica Online Training | Informatica Online Training in India Hyderabad | Best Informatica Online Training
    Informatica Online Training I have taken this course from Attain Technologies. Thay covered all the real time scenarios and their training way was very good approach is very much understandable
    Contact them on given contact number is +91 9052820000, +1 2092073642, Email:contact@attainonlinetraining.com
    Web: http://attainonlinetraining.com/it-informatica-online-training.html

    ReplyDelete
  3. it's a Nice article, very helpful for us and thank's for sharing. we are providing Informatica online training

    ReplyDelete
    Replies
    1. Java Online Training Java Online Training Java Online Training Java Online Training Java Online Training Java Online Training

      Hibernate Online Training Hibernate Online Training Spring Online Training Spring Online Training Spring Batch Training Online Spring Batch Training Online

      Delete
  4. Excellent piece of knowledge, I had come back to read concerning your web site from my friend shiva, bangalore. I have readed atleast eight posts of your website and let me tell you, your website provides the most fascinating information. This is the knowledge that I had been craving for, I am already your rss reader currently and that I would frequently be careful for the new posts. Thanks plenty another time, Regards,Informatica Online Training

    ReplyDelete
  5. Informatica Online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING http://www.21cssindia.com/courses/informatica-online-training-31.html The 21st Century Software Solutions of India offers one of the Largest conglomerations of Software Training, IT Support, Corporate Training institute in India - +919000444287 - +917386622889 - Visakhapatnam,Hyderabad Informatica Online Training, Informatica Training, Informatica, Informatica Online Training| Informatica Training| Informatica| "Courses at 21st Century Software Solutions
    Talend Online Training -Hyperion Online Training - IBM Unica Online Training - Siteminder Online Training - SharePoint Online Training - Informatica Online Training - SalesForce Online Training - Many more… | Call Us +917386622889 - +919000444287 - contact@21cssindia.com
    Visit: http://www.21cssindia.com/courses.html"

    ReplyDelete
  6. This comment has been removed by the author.

    ReplyDelete
  7. Informatica Online Training very less prices only at Dwbiadda.com by real time Employee

    http://www.dwbiadda.com/course/informatica-online-training/

    --
    Thanks and Regards
    Your Best Online Training Partner
    Team DWBIADDA.com,
    www.dwbiadda.com
    http://dwbiadda.blogspot.in/
    Call +91-720-720-9005
    Mail:dwbiadda@gmail.com
    Skype: DWBIADDA

    ReplyDelete
  8. It was really a nice article and I was really impressed by reading this article. We are also giving all software Course Online Training. The Informatica Online Training is one of the leading Online Training institute in the world.

    ReplyDelete
  9. It was so nice article and useful to Informatica learners. we also provide Informatica Course online training our Cubtraining is leader in providing Software Training

    ReplyDelete
  10. excellent piece of information, I had come to know about your website from my friend kishore, pune,i have read atleast 8 posts of yours by now, and let me tell you, your site gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanx a lot once again, Regards, obiee training in hyderabad,informatica training in hyderabad

    ReplyDelete
  11. Nice post! Hamsini Technologies To provide Online IT Trainings. Informatica Training course will introduce learners to Informatica Introduction, Configuration, performing tasks such as creating transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data, Qualifier, source qualifier, SCD type and XML source, advance designer, planner & Mapping Features.

    Informatica Online training

    ReplyDelete

  12. Great post and informative blog.
    Informatica Training in bangalore,Informatica Training,Informatica Online Training.


    http://www.tekclasses.com/

    ReplyDelete

  13. Great post and informative blog.
    Informatica Training in bangalore,Informatica Training,Informatica Online Training.


    http://www.tekclasses.com/

    ReplyDelete
  14. Great stuff provided by the Admin here… look into this for informatica online training

    ReplyDelete