Interested to Buy Any Domain ? << Click Here >> for more details...
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
- 5 Answers
- 8715 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rascal
connected lookup is used when we need to use dynamic cache,we can return multiple o/p&need to use default values...otherwise if we want to use same lookup multiple times in the mapping then we go for un-connected lookup..In this case we can use only static cache..
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / poluraju
u return multiple ports you can choose connected lookup.if u want to return only one port u can choose connected or unconnected lkp.but if we want to call the same lookup multiple time with different input for single row then we choose unconnected lkp...
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sandy
Connected Lookup :- When we require more than one row to be
output from the lookup.
UnConnected Lookup:- When we need only one port as output
from the lookup
| Is This Answer Correct ? | 1 Yes | 2 No |
When we want to return multiple ports from a mapping we wil
use connected lookup.
An connected lookup returns only one port from the t/r. If
we want to use lookup multiple times in a mapping and if we
want to lookup data only when the condition is true we will
use unconnected lookup. (if we dont want to look up all the
records and only some records)
regards,
rayudu
| Is This Answer Correct ? | 2 Yes | 3 No |
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
difference between informatica 8.1.1 and 8.6
Limitation of REPLACESTR. Is there any character limitation to it.
How to delete the (flat file) data in the target table after loaded.
What are the modules in Power Center
Tell me about informatica architecture.
Why we use stored procedure transformation?
How mapping parameter and variable works
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
Explain the tuning lookup transformation - informatica
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
Teradata 
