What is difference between a connected look up and
unconnected look up?

Answers were Sorted based on User's Feedback



What is difference between a connected look up and unconnected look up?..

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

What is difference between a connected look up and unconnected look up?..

Answer / prasuna

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

What is difference between a connected look up and unconnected look up?..

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

What is difference between a connected look up and unconnected look up?..

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

What is difference between a connected look up and unconnected look up?..

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

What is difference between a connected look up and unconnected look up?..

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

Post New Answer

More Informatica Interview Questions

how to connect two or more table with single source qualifier?

4 Answers   IBM,


what is size of u r database?

0 Answers  


What are the different threads in DTM process?

1 Answers  


write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,


Is it possible to create multiple domains on a single Informatica server?

0 Answers  






Differentiate between reusable transformation and mapplet.

0 Answers  


can any one explain me about junk dimension

4 Answers  


What is xml source qualifier transformation in informatica?

0 Answers  


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  


how can u approach u r client

2 Answers   CTS,


difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,


i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,


Categories