when will we use unconnected & connected lookup? How it
will effect on the performance of mapping?
- 5 Answers
- 14678 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
Slowly changing dimensions, types and where will you use them
How to do unit testing in informatica? How to load data in informatica ?
How do you load alternate records into different tables through mapping flow?
What are the designer tools for creating transformations?
can u any challenge your project?
list out all the transformations which use cache?
How to elaborate powercenter integration service?
How do we call shell scripts from informatica?
Explain the shared cache and re-cache?
What if the source is a flat-file?
What is workflow manager?
In warehouses how many schemas are there?
Separate from an archive server and a powerhouse?
What is meant by query override?
Differentiate between sessions and batches?
