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
- 16138 Views
- Accenture, I also Faced
- E-Mail Answers
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
What are the differences between oltp and olap?
What is the sql query overwrite in source qualifier in informatica
What is the scenario which compels informatica server to reject files?
Is it possible to use a client with different version than that of its Informatica server?
How to use pmcmd utility command?
Why union transformation is an active transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What does command task mean?
What is decode in static cache?
What is meant by a domain?
What is sorter transformation?
What is the fact table?
explain one complex mapping with logic? sales project?
What is the command used to run a batch?
Explain the features of connected and unconnected lookup.
