Unconnected Lookup transformation

Posted by
An unconnected Lookup transformation is separate from the pipeline in the mapping. We write an expression using the :LKP reference qualifier to call the lookup within another transformation.

Steps to configure Unconnected Lookup:
  1. Add input ports.
  2. Add the lookup condition.
  3. Designate a return value.
  4. Call the lookup from another transformation.

Example for create a unconnected Lookup Transformation
  1. Let us assume EMP will be source table and DEPT will be LOOKUP table.
  2. Create a target table T_UNCONN_LKP in target designer. Table should contain all ports of EMP table plus LOC.
  3. Go to the Mapping Designer.
  4. Click Mapping-> Create-> Give name. Ex: m_UNCONN_LKP
  5. Drag Source and Target table.
  6. Creat an EXPRESSION transformation and pass all ports from Source Qualifier to EXPRESSION transformation.
  7. Then connect all fields from EXPRESSION to target except DNAME.
  8. Create a LOOKUP transformation.
  9. As DEPT is the Source definition, click Source and then Select DEPT.
  10. Click Ok.
  11. Now Edit the Lookup Transformation. Go to Ports tab.
  12. As DEPTNO is common in source and Lookup, create a port IN_DEPTNO ports tab. Make it Input port only and Give Datatype same as DEPTNO.
  13. Designate LOC as Return Port. Check on R to make it.
  14. Now add a condition in Condition Tab.
  15. DEPTNO = IN_DEPTNO and Click Apply and then OK.
  16. Now we need to call this Lookup from Expression Transformation.
  17. Edit Expression transformation and create a new output port out_LOC of datatype as LOC. 
  18. Open the Expression editor and call Lookup as given below:
  19. We double click Unconn in bottom of Functions tab and as we need only DEPTNO, we pass only DEPTNO as input.
  20. Write the expression as :LKP.LKPTRANS(DeptNo)
  21. The final mapping looks like as below..
  22. Validate the call in Expression editor and Click OK.
  23. Then save the mapping.
  24. Create Session and Workflow. Run the workflow and see the data in target table.
  25. Note:
  26. Make sure to give connection information for all tables.
  27. Make sure to give connection for LOOKUP Table also.
Labels: , , ,

39 comments :

  1. robertNovember 14, 2012 at 6:56 PM

    I am William..I just browsing through some blogs and came across yours! Excellent blog, good to see someone actually uses for quality posts. Your site kept me on for a few minutes unlike the rest :) Keep up the good work!Thanks for sharing a important information on informatica

    ReplyDelete
  2. AnonymousApril 8, 2013 at 12:57 PM

    superb display bro:-):-)...

    ReplyDelete
  3. AnonymousApril 26, 2013 at 4:52 PM

    Would it be possible to share - Why should we use unconnected lookups in contrast to connected lookups? thanks in advance

    ReplyDelete
  4. kits onlineSeptember 21, 2015 at 11:51 AM

    good article.
    SQL and Plsql Training

    SQL Server 2012 DBA Training

    SQL Server 2012 Training

    Tableau Training

    Teradata Training

    Tibco Training

    ReplyDelete
  5. Vinod kumarOctober 20, 2015 at 10:00 AM

    This is very informative and this is very usefull to us.

    Informatica online training , informatica training in bangalore

    informatica online training , informatica training in bangalore , informatica training , informatica online trainig in bangalore

    ReplyDelete
  6. Tek ClassesNovember 12, 2015 at 3:52 PM

    This is very good information
    informatica training , infromatica online training, informatica training in bangalore, infromatica online training in bangalore

    ReplyDelete
  7. christianastevesNovember 9, 2016 at 4:26 PM

    The style of Article is really good. The information provided is precise and factual. Click on Lookup transformation for more info

    ReplyDelete
  8. Teju TejuJuly 20, 2018 at 6:21 PM

    Thank you.Well it was nice post and very helpful information on Informatica Online Training Hyderabad

    ReplyDelete
  9. JamessJuly 6, 2019 at 3:14 PM

    If you are a company owner, you must be conscious of the fact that Payroll calculation does demands large amount of time and man force. Then came into existence QuickBooks Payroll and QuickBooks Support customer care telephone number team.

    ReplyDelete
  10. Bryan WillsonJuly 6, 2019 at 4:06 PM

    Amended income tracker, pinned notes, better registration process and understandings on homepage are the large choice of general alterations for several versions of QuickBooks 2015. It can benefit for QuickBooks Enterprise Technical Support Number to acquire technical support for QuickBooks.

    ReplyDelete
  11. QuickBooks Payroll Support Phone NumberJuly 8, 2019 at 11:51 AM

    QuickBooks Enterprise errors troubling you? Are you currently fed up with freezing of QuickBooks? If yes, you then have browsed off to the right place. QuickBooks Enterprise Technical Support Number is successfully delivering the whole world class technical assistance for QuickBooks Enterprise at comfort of your house.

    ReplyDelete
  12. BlogsillyJuly 8, 2019 at 5:00 PM

    QuickBooks Online Payroll Contact Number
    So so now you are becoming well tuned directly into advantages of QuickBooks online payroll in your business accounting but because this premium software contains advanced functions that will help you and your accounting task to accomplish, so you could face some technical errors when using the QuickBooks payroll solution. In that case, Quickbooks online payroll support number provides 24/7 make it possible to our customer. Only you must do is make a person call at our toll-free QuickBooks Payroll tech support number . You could get resolve most of the major issues include installations problem, data access issue, printing related issue, software setup, server not responding error etc with this QuickBooks payroll support team.

    ReplyDelete
  13. steffanJuly 10, 2019 at 11:26 AM

    By using Quickbooks Payroll Customer Support Number, you can create employee payment on time. In any case, you will be facing some problem when making use of QuickBooks payroll such as for instance issue during installation, data integration error, direct deposit issue, file taxes, and paychecks errors, installation or up-gradation or simply just about virtually any than you don’t panic, we provide quality QuickBooks Desktop Payroll Support Phone Number.

    ReplyDelete
  14. steffanJuly 11, 2019 at 10:29 AM

    Just dial QuickBooks Support and inform us the QuickBooks product name for which you need QuickBooks help by our experts. Our team will guide you for every single product of QuickBooks whether QuickBooks Enterprise Support, Accountant, Pro, and Premier.

    ReplyDelete
  15. QuickBooks Payroll SupportJuly 12, 2019 at 10:37 AM

    QuickBooks Support Phone Number Services provide approaches to your entire QuickBooks problem and also assists in identifying the errors with QuickBooks data files and diagnose them thoroughly before resolving these issues.

    ReplyDelete
  16. Jack DorseyJuly 15, 2019 at 4:30 PM

    QuickBooks Enterprise Support Number provides you with proper assistance whenever you want it. You can avail Enterprise Support using E-mail yet QuickBooks Enterprise support number serves to be the best form of assistance. Here our experts will answer your call and supply you perfect solutions on QuickBooks Enterprise resolving most of the issues faced by you.

    ReplyDelete
  17. kevin32July 16, 2019 at 12:13 PM

    Accountant: in the event that you handle accounts department of assorted companies or institutes etc. then QuickBooks Enterprise Support Number industry version is of great use.
    Non-Profit: Running a non-profit organisation may also be a troublesome task as well as monitored properly.

    ReplyDelete
  18. kevin32July 17, 2019 at 12:01 PM

    Accountant: in the event that you handle accounts department of assorted companies or institutes etc. then QuickBooks Enterprise Tech Support Phone Number industry version is of great use.

    ReplyDelete
  19. MathewJuly 17, 2019 at 1:37 PM

    Get on the spot support for QuickBooks for rectifying the technical glitches:
    Give a call at QuickBooks Technical Support Phone Number, if you are encountering any difficulties which are mentioned above.

    ReplyDelete
  20. QuickBooks Payroll Support Phone NumberJuly 22, 2019 at 12:29 PM

    individuals and so they find ways to invent options for daily tasks. If you are a company owner, you must be conscious of the fact that Payroll calculation does demands large amount of time and man force. Then came into existence QuickBooks Technical Support Number customer care telephone number team.

    ReplyDelete
  21. kevin32July 23, 2019 at 12:29 PM

    Intuit has developed these items by keeping contractor’s needs in mind; also, looked after the application solution in line with the company size. At the moment, QuickBooks Support Phone Number software covers significantly more than 80% associated with small-business market share.

    ReplyDelete
  22. QuickBooks Payroll SupportJuly 24, 2019 at 3:55 PM

    The QB technicians are spontaneous and diligent to fix any QB issue , So business now conserve money as well time by calling the experts . One you connect to them the techies here to assist you the best way they may be able. These are typically prompt and responsive in resolving the matter. Resolve any Support For QuickBooks issue because of the QB technicians instantly .

    ReplyDelete
  23. QuickBooks Support Phone NumberJuly 25, 2019 at 10:45 AM

    Using this QuickBooks Support Number best and great accounting software, it is simple to and quickly track your online business all income and expenses, easily track your instalments, sales, and inventory,

    ReplyDelete
  24. steffanJuly 25, 2019 at 1:03 PM

    Advanced Financial Reports: The user can surely get generate real-time basis advanced reports by using QuickBooks. If one is not known of the feature, then, you can easily call our Quickbooks Tech Support Phone Number . They will surely provide you with the necessary information to you.

    ReplyDelete
  25. QuickBooks Payroll SupportJuly 30, 2019 at 11:57 AM

    Get excellent QuickBooks help for Accounting or bookkeeping to maintaining all kind of operations for all independent(small or mid size) businesses. Our team is ready to support you for all the updates or changes made by Intuit QuicKbooks Customer Support Phone Number.

    ReplyDelete
  26. accountingwizardsJuly 30, 2019 at 2:30 PM

    QuickBooks has completely transformed the way people used to operate their business earlier. To get familiar with it, you should welcome this positive change. Supervisors at QuickBooks Tech Support Phone Number have trained all of their executives to combat the issues in this software. Utilizing the introduction of modern tools and approaches to QuickBooks, you can test new techniques to carry out various business activities. Basically, this has automated several tasks that have been being done manually for a long time. There are lots of versions of QuickBooks and each one has a unique features.

    ReplyDelete
  27. steffanJuly 31, 2019 at 11:05 AM

    Amended income tracker, pinned notes, better registration process and understandings on homepage are among the list of general alterations for several versions of QuickBooks 2015. It can benefit for QuickBooks Enterprise Tech Support Number to acquire technical help & support for QuickBooks.

    ReplyDelete
  28. JamessAugust 1, 2019 at 10:21 AM

    At QuickBooks Phone Support we work with the principle of consumer satisfaction and our effort is directed to give a transparent and customer delight experience. A timely resolution into the minimum span is the targets of QuickBooks Support Toll-Free Pro-Advisors. The diagnose and issue resolution process happens to be made detail by detail and is kept as simple as possible.

    ReplyDelete
  29. xpertAugust 14, 2019 at 11:50 AM

    QuickBooks has been recognised around the globe as the most effective and useful accounting software. Quickbooks Technical support customer service executives that really work with you on QuickBooks Support Phone Number are responsible to manage every Quickbook technical issue that creates in QuickBooks software. It is possible to dial the QuickBooks Payroll Support Number to possess a spoken language because of the QuickBooks Specialists or else you can even talk to them by victimization the chat choice on our internet site.

    ReplyDelete
  30. kevin2August 14, 2019 at 12:12 PM

    QuickBooks Payroll Technical Support Number so that you take advantage out of your business accounting software. By assisting you to customize its settings, our experts will make sure that your QuickBooks Payroll software works optimally for you so you are able to save time, reduce errors, and drive better business results.

    ReplyDelete
  31. kevin2August 20, 2019 at 11:58 AM

    What’s more important is to obtain the proper help at the right time? Your own time is valuable. You must invest it in an essential business decision and planning. Anytime and anywhere you can solve your worries from our experts and Proadvisors via QuickBooks Support Phone Number.

    ReplyDelete
  32. Tech Customer Support NumberOctober 7, 2019 at 11:44 AM


    Amazing Post Man, too good!
    While going through your wonderful Post, I was able to connect it well with my problem. You have explained the concept in layman language that is well understood and the facts you have presented are very authentic. I personally admire your writing style. To manage your time more efficiently in your business, QuickBooks accounting software is the most prominent solution. While working on the application, you face some errors; one such is QuickBooks Error H505. Thus, to fix QuickBooks Error H505 you can contact QuickBooks Helpline Number +1 833-228-2822 and avail prominent solutions from our QuickBooks Experts.

    ReplyDelete
  33. outsourcingall@outlook.comOctober 7, 2019 at 4:11 PM


    smart outsourcing solutions is the best outsourcing training
    in Dhaka, if you start outsourcing please
    visit us: graphic design training
    digital marketing training

    ReplyDelete
  34. thomasJune 10, 2020 at 11:01 AM

    Very helpful and i would like to thanks!
    Do you want QuickBooks trial for desktop? Get live support 24*7 from QuickBooks expert on tool-free Number.
    Click here to know how to Grab QuickBooks trial for desktop
    Dial for any tech support: 1-844-908-0801

    ReplyDelete
  35. Quickbooks Phone NumberJune 12, 2020 at 10:58 AM

    Very helpful and i would like to thanks!Do you want QuickBooks Payroll error 557? Get live support 24*7 from QuickBooks expert on tool-free Number.Click here to know how to Grab QuickBooks trial for desktop Dial for any tech support:1-855-615-2111

    ReplyDelete
  36. Quickbooks Phone NumberJuly 7, 2020 at 10:52 AM

    Very helpful and i would like to thanks!Do you want QuickBooks Payroll Support Number Get live support 24*7 from QuickBooks expert on tool-free Number.Click here to know how to Grab QuickBooks trial for desktop Dial for any tech support:1-855-511-6911

    ReplyDelete
  37. Quickbooks Phone NumberJuly 7, 2020 at 11:21 AM

    Very well explained blog click here for QuickBooks Proadvisor Support Phone Number for more details dial on our 24*7 and Dial 1-855-511-6911 QuickBooks Enterprise support Number

    ReplyDelete
  38. PushbaOctober 16, 2020 at 10:42 PM

    Very helpful and i would like to thanks
    IELTS Coaching in chennai

    German Classes in Chennai

    GRE Coaching Classes in Chennai

    TOEFL Coaching in Chennai

    spoken english classes in chennai | Communication training

    ReplyDelete
  39. AnonymousNovember 20, 2020 at 11:36 PM

    Great Informative post. I really Appreciate your work. Thank you for sharing the informationsalesforce course in chennai

    software testing course in chennai

    robotic process automation rpa course in chennai

    blockchain course in chennai

    devops course in chennai

    ReplyDelete

Subscribe to: Post Comments ( Atom )
> Related Posts with Thumbnails
 

Copyright © 2012. GS dot net - All Rights Reserved - Design by BTDesigner - Proudly powered by Blogger