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
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is DR strategy for Informatica project?
What is aggregate cache in aggregator transformation?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What are the different versions of informatica?
How we can create indexes after completing the loan process?
As union transformation gives UNION ALL output, how you will get the UNION output?
What are the types of lookup transformation?
what is size of u r database?
Parameter and variable differences
What are connected or unconnected transformations?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is flashback table ? Advance thanks
where to store informatica rejected data?
How to create Target definition for flat files?