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
- 16384 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
what is the size of u r source(like file or table)?
Describe the impact of several join conditions and join order in a joiner transformation?
How can we improve session performance in aggregator transformation?
permutations of mapplet
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to elaborate tracing level?
What do think which one is the better joiner or look up?
What will be the approach?
Explain the different lookup methods used in informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Differentiate between joiner and lookup transformation?
have u done any performance tuning? how u ll do?
What is Index Caches size?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
