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
- 16601 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
How do you update the records with or without using update strategy?
How do you promote a non-reusable transformation to reusable transformation?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is informatica?
How many numbers of sessions can one group in batches?
Target increases every day even though no new record was inserted
Enlist the advantages of informatica.
what is INFORMATICA TESTING process
Where is metadata stored?
What is the command used to run a batch?
Global and Local shortcuts. Advantages.
How might one distinguish in the case of mapping is right or not without associating session?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Why do you use Mapping Parameter and mapping variable?
Explain direct and indirect flat file loading (source file type) - informatica
