We can achieve better perfomance using sorter before an
aggragator. Then what is the significance of 'Sorted Input'
check in aggregator ?? Please let me know the difference ??
Answer Posted / guest
Integration service is not intelligent enough to know the
data is sorted. So If "Sorted Input" Option is checked,
then Integration service understands that the input data to
the sorter Transformation is sorted.
Regards,
Kumar
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Write the prerequisite tasks to achieve the session partition?
How do you load unique records into one target table and duplicate records into a different target table?
hi real timers . iam waiting for ur reply regarding ETL TESTING
explain abt ur project architecture?
Design time, run time. If you don't create parameter what will happen
Global and Local shortcuts. Advantages.
How to do unit testing in informatica? How to load data in informatica ?
In warehouses how many schemas are there?
What are the differences between oltp and olap?
Tell me about Propagate functions in informatica
How does a sorter cache works?
What is persistent lookup cache?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is sequence generator transformation in informatica?
How do you remove duplicate records in informatica? And how many ways are there to do it?