when will we use unconnected & connected lookup? How it
will effect on the performance of mapping?
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 you know about transaction control transformation?
What is informatica metadata and where is it stored?
What is the use of transformation?
What is the format of informatica objects in a repository?
What is the scenario which compels informatica server to reject files?
Can we create a Integration service without a Repository service and vice versa?
explan ur project architecture?
How might you approve all mappings in the archive all the while?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How do you set a varible in incremental aggregation
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is native users?
Can u generate reports in Informatica?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance