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

Typo error in my previous post.

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 Aggregation Transformation is sorted.

Regards,
Kumar

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the basic requirements to join two sources in a source qualifier transformation using default join?

695


Define mapping and session?

675


Can you use flat files in Mapplets.

2309


What is expression transformation?

718


can anyone suggest best free Talend data integration training online

1348






waht type of interface is used for testing the data in informatica

1924


Which transformation is needed while using the Cobol sources as source definitions?

816


Why filter transformation is an active one?

669


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

644


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1787


is it possible to index the data in cache of lkp transformation ?

1624


Enlist the differences between database and data warehouse.

638


How can you validate all mappings in the repository simultaneously?

891


Enterprise data warehouse your projects phase by phase explain?

1562


What is the Process to creating lookup transformation in informatica

678