Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between a connected look up and
unconnected look up?
- 6 Answers
- 25548 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ande
Connected LookUp returns multiple values to other
Transformation whereas unconnected lookup return single
value, If condtion is match then connected lookup returns
user defined default values whereas unconnected lookup
returns null values, connected lookup supports dynamic as
well as static caches whereas unconnected lookup supports
static cache only
regards,
ande
| Is This Answer Correct ? | 52 Yes | 6 No |
1) A connected Lookup transformation receives input values
directly from another transformation in the pipeline.
An unconnected Lookup transformation receives input values
from the result of a :LKP expression in another
transformation. You can call the Lookup transformation more
than once in a mapping.
2)IN connected The Integration Service passes return values
from the query to the next transformation.
In Unconnected The Integration Service returns one value
into the return port of the Lookup transformation.
3)Connected uses Dynamic or Static Cache,whereas
Unconnected use a static cache
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / suresh
1.conneted T/r takes multiple inputs and gives multiple
outputs
where as unconnected t/r takes multiple inputs but gives
single output
2. in connected lookup input, output, lookup ports are
available
where as in unconnected look up having input,output,lookup
as well as return port
3. connected t/r used dynamic and static cache
where as unconnected t/r uses only dynamic cache
| Is This Answer Correct ? | 19 Yes | 13 No |
Answer / parveen kumar
The imp. diff b/w connected and unconnected lookup is regarding to their performance. Suppose if a lookup condition is true only for one thousand rows out of 1M rows. Then we must use unconnected lookup in such cases by calling the lookup only in else condition i.e. we can write in EXP that if ID(suppose this is I/N port)is null, then -1 else :LKP.(lookup transformation name). So in this case, it'd hit the DB only 1000 times. But if we use connected lookup, it'd hit the DB 1M times no matter whether the condition is true or not.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / rameshk
which t/r see a part of mapping is called connected
which is not part of mapping is called unconnected
the main diffrence between connected and unconnected lookup is the connected lookup connect eithere source or target but unnconnecte either nd nor connect to source or target.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mln
connected look up is not reusable and only one output port
are return port will be there at a time and this is more
faster than connected.
| Is This Answer Correct ? | 4 Yes | 44 No |
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Whats there in global repository
What is exclusive and normal mode for repository services?
Explain about cumulative Sum or moving sum?
What are the phases in SDLC?
What is rank transformation in informatica
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
what is mapping override?
In a sequential batch can u run the session if previous session fails?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
what is meant by data driven.. in which scenario we use that..?
Teradata 
