when will we use unconnected & connected lookup? How it
will effect on the performance of mapping?

Answer Posted / sweta kedia

A. Connected Lookup
Receives input values directly from the pipeline.
We can use a dynamic or static cache
Supports user-defined default values

Unconnected Lookup
Receives input values from the result of a :LKP expression
in another transformation.
We can use a static cache
Does not support user-defined default values

When you compared both basically connected lookup will
return more values and unconnected returns one value. conn
lookup is in the same pipeline of source and it will accept
dynamic caching. Unconn lookup don't have that faclity but
in some special cases we can use Unconnected. if output of
one lookup is going as input of another lookup this
unconnected lookups are favourable
Moreover if the mapping requires multiple lookup using same
lookup conditions then its better to use unconnected lookup
& call the lookup wherever required.This also prevents the
mapping from being complex.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1900


What is the function of aggregator transformation?

818


Define joiner transformation?

811


what is SDLC way of code development?

1775


What is the use of code page?

787


What is flashback table ? Advance thanks

1700


tell me 5 session failure in real time how can you solve that in your project?

1891


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1830


What are the different versions of informatica?

951


What are session parameters ? How do you set them?

1587


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1920


How to improve the performance of a session using sorter transformation?

926


What is decode in static cache?

804


What is Cognos script editor?

3957


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

824