When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
- 5 Answers
- 6797 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 is mapping optimization? wat are the techniques for tat
What is the use of target designer?
What are roles and groups and benefits of using them?
How to update or delete the rows in a target, which do not have key fields?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
what is the difference between informatica6.1 and infomatica7.1
what is the use of Data Mart?
design of staging area?
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
What is the difference between bitmap and btree index?
Is it possible to create multiple domains on a single Informatica server?
Teradata 
