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
- 16428 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 is SDLC way of code development?
What are the different components of powercenter?
How to create a non-reusable instance of reusable transformations?
Explain pushdown optimization and types in informatica
Explain the types of lookup transformation?
Define enterprise data warehousing?
Why do we need informatica?
Define Pmrep command?
Explain the tuning lookup transformation - informatica
What is informatica metadata and where is it stored?
Informatica Checkpoints
Different sorts of metadata that stores in the storage facility?
What are the uses of etl tools?
What are the reusable transformations?
Performance tuning( what you did in performance tuning)
