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
- 16391 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
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what is informatica metadata?
Explain the different dimensions.
How big was your fact table
What are the different options available for update strategy?
What are the restrictions of union transformation?
What do you understand by a term domain?
What is a grid in Informatica?
What are the settings that you use to configure the joiner transformation?
How to call shell scripts from informatica?
What is a repository manager?
server hot-ws270 is connect to Repository B. What does it mean?
What are the different clients of powercenter?
How does a sorter cache works?
What do you understand by SOA of Informatica?
