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
- 16136 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
What is target load order?
expain about the tune parameters?
What is an Integration service in Informatica?
What are different types of transformations available in informatica?
How many ways a relational source definition can be updated and what are they?
What is the use of target designer?
What is a transaction control transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is meant by incremental aggregation?
How can you differentiate between powercenter and power map?
What are the types of caches in lookup? Explain them.
What are the features of complex mapping?
How to start a workflow using pmcmd command?
How we can create indexes after completing the loan process?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
