if we r using aggregator we enabled sorted input but the
records r not sorted what happen?
Answer Posted / vaibhav bhandeo
This technique is used when you want a performnce boost.
There will be an aggrigator cache created and will be
indexed. Although you have not given a sorted input it will
still work fine as it is indexed in cache. Please note this
is not like a page fault where you have to bring the page
from the secondary memory when not found in primary memory.
| Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
What do you understand by term role-playing dimension?
How are the sources and targets definitions imported in informatica designer?
How you can differentiate between connected lookup and unconnected lookup?
What is confirmed fact in dataware housing?
What are the new features of informatica 9.x developer?
Explain sessions?
How might you approve all mappings in the archive all the while?
How to generate sequence numbers?
Explain your project of banking domian.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What do think which one is the better joiner or look up?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
COM components can be used in Informatica
What is the difference between a connected look up and unconnected lookup?
What are the data movement modes in informatica?