when will we use unconnected & connected lookup? How it
will effect on the performance of mapping?
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 the meaning of decode in informatica?
What is decode in informatica?
Define mapplet?
What are mapplets?
How to extract sap data using informatica?
Is there any way to read the ms excel datas directly into informatica?
How to implement security measures using repository manager?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Tell me about Propagate functions in informatica
Explain the difference between mapping parameter and mapping variable?
To import the flat file definition into the designer where should the flat file be placed?
Sequence generator, when you move from develoment to production how will you reset
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Informatica settings are available in which file?
What is the sql query overwrite in source qualifier in informatica