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 is a pre-defined event and user-defined event?
Mention a few design and development best practices for informatica?
how tokens will generate?
How are indexes created after completing the load process?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Explain the difference between mapping parameter and mapping variable?
What are the prerequisite tasks to achieve the session partition?
Why update strategy and union transformations are active?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How would you join a node to the already existing domain?
Enlist the tasks for which source qualifier transformation is used.
Is it possible to create multiple domains on a single Informatica server?
what are the deliverables?in your project?
Parameter and variable differences
How to delete duplicate row using informatica?