GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 233 of 327    Print  
How to return more than two values from an unconnected lookup?

  
Total Answers and Comments: 3 Last Update: February 29, 2008     Asked by: Rajat 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 22, 2007 05:41:21   #1  
sreedhar        

RE: How to return more than two values from an unconne...
Using lookup SQL override you can do that one.
In that SQL you can concatnate two values whatever you want
like empno||'~'|| ename
after that you can take expression t/f using that one
You split two values
If i am wrong plz correct that one

 
Is this answer useful? Yes | No
December 06, 2007 07:04:01   #2  
Thananjayan Member Since: November 2007   Contribution: 15    

RE: How to return more than two values from an unconnected lookup?
unconnected look up can't return more than one value.
 
Is this answer useful? Yes | No
February 29, 2008 06:00:33   #3  
Amritendra kumar Member Since: February 2008   Contribution: 16    

RE: How to return more than two values from an unconnected lookup?
unconnected lookup only return 1 port but if you want to return 2 port then u have to play mind game mean u hav to use concatenate operator in expression editor.
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape