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
- 16418 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / v.ramakrishna
when it comes to the matter of performance optimization we
can understand the diff between conn lookup and unconn
lookup y bcoz in conncted lookup it will give more than one
output. when compared with the performance of unconn lookup
it is some what slower bcoz the execution times in conn
lookup is equal with no of records present in source . so
it will increase running time . where as in unconn lookup
it executes only for records which satisfy the given
condition so no need to call lookup for each and every
record unneccesarily. so it leads to performance
development in unconn lookup compared wth conn lookup.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
tell me about your project functionality
What is a code page?
Sequence generator, when you move from develoment to production how will you reset
What is the difference between informatica 7.0 and 8.0?
Please let me know how to make encryption and decryption with example?
Enlist the tasks for which source qualifier transformation is used.
How do you update the records with or without using update strategy?
What is a mapplet/worklet in informatica?
What is substr in informatica?
How to update or delete the rows in a target, which do not have key fields?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How to create or import flat file definition in to the warehouse designer?
What are the types of lookup transformation?
What are the static cache and dynamic cache in informatica?
What is an aggregator transformation?
