Interested to Buy Any Domain ? << Click Here >> for more details...
when will we use unconnected & connected lookup? How it
will effect on the performance of mapping?
- 5 Answers
- 16425 Views
- Accenture, I also Faced
- E-Mail Answers
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
Explain lookup transformation source types in informatica
Briefly define reusable transformation?
Global and Local shortcuts. Advantages.
Explain pushdown optimization $pushdownconfig parameter - informatica
What is standalone command task?
How to create or import flat file definition in to the warehouse designer?
What is transformation?
define galaxy repository in informatica
In informatics server which files are created during the session rums?
Explain the mapping variable usage example in informatica
Describe expression transformation?
What is the need for an etl tool?
Tell me about MD5 functions in informatica
What are the differences between source qualifier and joiner transformation?
How to create Target definition for flat files?
