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
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is the function of aggregator transformation?
Define joiner transformation?
what is SDLC way of code development?
What is the use of code page?
What is flashback table ? Advance thanks
tell me 5 session failure in real time how can you solve that in your project?
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
What are the different versions of informatica?
What are session parameters ? How do you set them?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to improve the performance of a session using sorter transformation?
What is decode in static cache?
What is Cognos script editor?
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?