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


Please Help Members By Posting Answers For Below Questions

What is the meaning of decode in informatica?

897


What is decode in informatica?

851


Define mapplet?

834


What are mapplets?

1036


How to extract sap data using informatica?

822


Is there any way to read the ms excel datas directly into informatica?

791


How to implement security measures using repository manager?

865


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

2375


Tell me about Propagate functions in informatica

736


Explain the difference between mapping parameter and mapping variable?

828


To import the flat file definition into the designer where should the flat file be placed?

871


Sequence generator, when you move from develoment to production how will you reset

1687


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

2533


Informatica settings are available in which file?

795


What is the sql query overwrite in source qualifier in informatica

861