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
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Define mapping and session?
Can you use flat files in Mapplets.
What is expression transformation?
can anyone suggest best free Talend data integration training online
waht type of interface is used for testing the data in informatica
Which transformation is needed while using the Cobol sources as source definitions?
Why filter transformation is an active one?
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?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
is it possible to index the data in cache of lkp transformation ?
Enlist the differences between database and data warehouse.
How can you validate all mappings in the repository simultaneously?
Enterprise data warehouse your projects phase by phase explain?
What is the Process to creating lookup transformation in informatica