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
- 16592 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 informatica metadata?
How can informatica be used for an organization?
What are the informatica performance improvement tips
tell me about your project functionality
What is dimensional table? Explain the different dimensions.
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is a shortcut and copy in Informatica and how two are different with each other?
Explain the different lookup methods used in informatica?
What is workflow manager?
What is aggregator transformation in informatica?
What are active and passive transformations?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Explain pushdown optimization and types in informatica
Explain the types of lookup transformation?
What is dimensional table?
