when will we use unconnected & connected lookup? How it
will effect on the performance of mapping?
Answer Posted / nag
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
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain load alternative records / rows into multiple targets - informatica
What is the difference between informatics 7x and 8x and what is latest version?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Explain 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?
Parameter and variable differences
write a query to retrieve the latest records from the table sorted by version(scd)
What are junk dimensions?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is a pre-defined event and user-defined event?
What do mean by local and global repository?
Explain the difference between mapping parameter and mapping variable?
What is the difference between stop and abort in informatica
What is dynamic cache?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?