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 measure objects?
What happens when a session fails and you click on recover?
Explain direct and indirect flat file loading (source file type) - informatica
What are Dimensional table?
If informatica has its scheduler why using third party scheduler?
Which is the t/r that builts only single cache memory?
Is there any way to read the ms excel datas directly into informatica?
Could you explain what is enterprise data warehouse?
What are pre and post-session shell commands?
tell me about your project functionality
How we can create indexes after completing the load process?
can u any challenge your project?
how we can load rejected record's at run time?(not through bad files)
Briefly define reusable transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com