- Learning Informatica PowerCenter 10.x（Second Edition）
- Rahul Malewar
- 151字
- 2021-07-02 20:55:51
Using Sorted Input
It is always recommended that we pass sorted input to aggregator transformation as this will enhance the performance. When you pass the sorted input to aggregator transformation, integration services enhance the performance by storing less data in cache. When you pass unsorted data, aggregator transformation stores all the data into cache, which takes more time. When you pass the sorted data to aggregator transformation, aggregator transformation stores comparatively less data. The aggregator passes the result of each group as soon as the data for the particular group is received.
Note that aggregator transformation does not sort the data. If you have unsorted data, use sorter transformation to sort the data, and then pass the sorted data to the aggregator transformation to enhance the performance.
When you pass the sorted data to the aggregator transformation, check the Sorted Input option in the properties as shown in the following screenshot:
推薦閱讀
- Java面向對象軟件開發
- 微服務與事件驅動架構
- Selenium Design Patterns and Best Practices
- 人人都懂設計模式：從生活中領悟設計模式（Python實現）
- Learning Network Forensics
- Java項目實戰精編
- Keras深度學習實戰
- Create React App 2 Quick Start Guide
- MySQL從入門到精通（軟件開發視頻大講堂）
- Go語言編程
- C語言程序設計與應用（第2版）
- Java Web開發實例大全（基礎卷） (軟件工程師開發大系)
- scikit-learn Cookbook（Second Edition）
- Raspberry Pi Robotic Projects
- Learning Network Programming with Java