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.


46 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
  2. it's a Nice article, very helpful for us and thank's for sharing. we are providing Informatica online training

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

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

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


    http://www.tekclasses.com/

    ReplyDelete

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


    http://www.tekclasses.com/

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

    ReplyDelete
  9. Wow amazing i think these are the mistakes i have repeatedly doing when writing with the content. Especially by checking with the spelling i am spending much time. And some distractions likewise you are telling by checking with the email and so on. I hope it will be useful for me in future. Please keep update like this

    SAP Training in Chennai

    SAP ABAP Training in Chennai

    ReplyDelete

  10. QuickBooks has made payroll management quite definitely easier for accounting professionals. There are so many individuals who are giving positive feedback if they process payroll QuickBooks Payroll Support Phone Number QB desktop and online options.

    ReplyDelete
  11. Contact our Technical Team with QuickBooks Tech Support Nowadays it is a sizable challenge for business organizations to have an excellent means to fix manage their business accounts in a convenient way. To use a fruitful organization, you have to have a powerful account management process to cultivate and lead.

    ReplyDelete
  12. QuickBooks Enterprise Technical Support Number is sold as an all within one accounting package geared towards mid-size businesses that do not require to manage the accounting hassle by themselves. The many industry specific versions add cherry regarding the cake.

    ReplyDelete
  13. By using QuickBooks Online Payroll Contact Number
    , you're able to create employee payment on time. However in any case, you might 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 some other than you don’t panic, we provide quality QuickBooks Payroll help service. Here are some features handle by our QB online payroll service.

    ReplyDelete
  14. Each one of these issues mentioned above are a couple of types of what kind of tech glitches users may face. QuickBooks Enterprise help is the only solution when it comes to selection of issues. So, contact with our QuickBooks support team with the QuickBooks Enterprise customer support number to enjoy all the latest plans and services made available from us globally. Dial our QuickBooks Enterprise Tech Support Number to get an immediate QuickBooks help.

    ReplyDelete
  15. Every user can get 24/7 support services with our online technical experts using QuickBooks support phone number. When you’re stuck in a situation for which you can’t discover a way to eliminate a problem, all you need is to dial QuickBooks Customer Service. Show patience; they are going to inevitably and instantly solve your queries.

    ReplyDelete
  16. In this internet site, we are going to enable you to experience to make and place up the checklist for employee payment. To have more enhanced results and optimized benefits, you are able to take the help of experts making a call at QuickBooks 24/7 Payroll Support Phone Number USA.

    ReplyDelete
  17. Comprises of an attractive lot of accounting versions, viz., QuickBooks Pro, QuickBooks Premier, QuickBooks Enterprise, QuickBooks POS, QuickBooks Mac, QuickBooks Windows, and QuickBooks Support Phone Number, QuickBooks is becoming a dependable accounting software that one may tailor depending on your industry prerequisite.

    ReplyDelete
  18. Look for QuickBooks Help & Support for 24*7 assistance
    QuickBooks Premier is very simple to make use of but errors may usually pop up at the time of installation, at the time of taking backup, while upgrading your software to your latest version etc.

    ReplyDelete
  19. Quickbooks Support Telephone Number
    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 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
  20. QuickBooks Technical Support helps to make the process far more convenient and hassle free by solving your any QuickBooks issues and error in only an individual call. We offer excellent tech support team services once we have the highly experienced and certified professionals to provide you the gilt-edge technical support services like.

    ReplyDelete
  21. you’ll additionally visit our web site to induce to understand additional concerning our code and QuickBooks Support Phone Number upgrades. you’ll scan in-depth articles concerning most of the errors and also how you can resolve them.

    ReplyDelete
  22. QuickBooks Tech Support Phone Number version is often additionally divided into QuickBooks professional, QuickBooks Premier and QuickBooks Enterprise. you’ll get the version and this can be additional apt for your business. you must additionally get guidance and support services for your code that square measure obtainable 24/7. If for those who come across any QuickBooks errors or problems or would like any facilitate, you’ll dial the direct line variety to succeed in the QuickBooks specialists.

    ReplyDelete
  23. So if you are facing any kind of errors or issues like unexpected QuickBooks Tech Support Phone Number and many more, every day with your Quickbooks accounting software then don’t concern yourself with it. Primeaxle always gives you the most effective & most amazing team to simply resolve or fix your errors or issues whenever you want.

    ReplyDelete
  24. QuickBooks Help & Support troubleshooting team makes it possible to in eradicating the errors that may pop-up quite often. There is common conditions that are encountered on daily basis by QuickBooks users. You might face problem in reconciling your hard earned dollars, there might be problems while you attempt to reconcile your bank cards, you will find problem in the settings of this report and so on and so on.

    ReplyDelete
  25. QuickBooks support telephone number it is easy to seek optimal solutions if any error hinders your work. With QuickBooks Tech Support Number Pro you can easily easily easily effortlessly create invoices and keep close monitoring of pretty much everything like exacltly what the shoppers bought,

    ReplyDelete
  26. A business must notice salaries, wages, incentives, commissions, etc., it has paid into the employees in a period period. Above all is the tax calculations must be correct and according to the federal and state law. Our Quickbooks Tech Support Phone Number will surely guide you in dealing with all this.

    ReplyDelete
  27. The aforementioned solutions must be sufficient in solving the QuickBooks Error 6000-301 and restoring your workflow. If you wish to know or are confused on some of the above-provided info, it is advisable to talk to a technical expert at QuickBooks Desktop support phone number.

    ReplyDelete
  28. QuicKbooks Customer Support Phone Number software is only developed by the Intuit for small and medium-size businesses. With this best and great accounting software, you can easily and quickly track your business all income and expenses, easily track your payments, sales, and inventory, simply store your customers and vendors all information and many more things.

    ReplyDelete
  29. QuickBooks Enterprise Tech Support Phone Number assists anyone to overcome all bugs from the enterprise types of the applying form. Enterprise support team members remain available 24×7 your should buy facility of best services.

    ReplyDelete
  30. All the flourishing Businesses square measure currently on QuickBooks Support because of the apprehend QuickBooks is the fact that the best once it involves accounting desires and management desires.

    ReplyDelete
  31. The locus of your services may be based upon delivering services in shortest span of that time period, without compromising aided by the quality of your services. Our support team is engaged in pre-research to create themselves prepared in advance for the possible errors of QuickBooks. This practice helps them produce you the specified wind up in the given time window. We are there to assist you at QuickBooks Support Phone Number 24*7 as we try not to disassociate ourselves together with your troubles even through the wee hours. QuickBooks Payroll Support Number advisors are certified Pro-advisors’ and has forte in furnishing any kind of technical issues for QuickBooks. They have been expert and certified technicians of these domains like QuickBooks accounting,QuickBooks Payroll, Point of Sales, QuickBooks Merchant Services and Inventory issues to provide 24/7 service to our esteemed customers. QuickBooks payroll Services provide methods to all your valuable QuickBooks problem and in addition assists in identifying the errors with QuickBooks data files and diagnose them thoroughly before resolving these problems.

    ReplyDelete
  32. Can help you every user task with QuickBooks Payroll Accounting software. Therefore you only want to install QuickBooks Payroll Technical Support Number software and fetch the information, rest all of the essential calculation will likely be done automatically because of the software.

    ReplyDelete
  33. We at QuickBooks Tech Support Phone Number, are among the leading providers of remote tech support for QuickBooks Payroll as well as other business accounting software. We are backed by a group of highly experienced and knowledgeable technicians.

    ReplyDelete

  34. QuickBooks Tech Support Phone Number Toll-Free offers an extensive financial solution, where it keeps your entire business accounting requirements in one single place. From estimates to bank transfers, invoicing to tracking your expenses and staying on top of bookkeeping with regards to tax time, it really is prepared for many from it at one go.

    ReplyDelete
  35. We are the one stop solution to all your glitches in the Quickbooks Payroll Support Phone Number 1-800-986-4607. We are Providing immediate & effective response to the user. Our team constitutes of various qualities.Our team is very friendly & polite. So, whatever the issue you are preoccupied .

    ReplyDelete
  36. Get connected with QuickBooks Phone Number Support +1(800)986-4591, to resolve error problems in the software. The experts deployed on the support line is to deliver immediate assistance regarding QuickBooks & its issues. If having trouble in QuickBooks, get connected with the experts by calling on the support phone Number. For More Visit: https://www.quickbooksphonenumbersupport.com/

    ReplyDelete
  37. Do you want help to get your QuickBooks issues resolved in seconds? If yes, Dial our QuickBooks Customer Service Number 855-907-0406 now! We will let you do your accounting duties without any interruptions.

    ReplyDelete
  38. Nice Blog ! Do you Need instant help fixing problems with your QuickBooks? Now dial our QuickBooks Payroll Support Phone Number 855 -9O7-O4O6! We have technical experts who can instantly fix your problems.

    ReplyDelete
  39. Dealing with QuickBooks Problems is no more a hassle now! Dial QuickBooks Support Phone Number 855-907-0406 when you experience the issue.
    View on Map: QuickBooks Customer Service

    ReplyDelete
  40. If you need help in solving issues you are facing in any of the above versions, you can connect with us at our QuickBooks Support Phone Number New York 855-907-0406.
    View On Map: QuickBooks Support Phone Number.

    ReplyDelete
  41. A minor/major security setting update is done by the bank that requires re-connection with the bank so that the updated settings can be taken correctly. If you would like to learn how to Troubleshoot Quickbooks Error 9999, you can continue reading this blog.

    ReplyDelete