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
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are the performance considerations when working with aggregator transformation?
what is the Default Source Option For Update Strategy Transformation?
What is rank index in rank transformation?
State the differences between sql override and lookup override?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is option by which we can run all the sessions in a batch simultaneously?
How to open an older version of an object in the workspace?
What is the meaning of decode in informatica?
Mention some types of transformation?
explain one complex mapping with logic? sales project?
Explain the shared cache and re-cache?
where to store informatica rejected data? How to extract the informatica rejected data?
What do you understand by SOA of Informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?