- 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:
推薦閱讀
- ASP.NET Web API：Build RESTful web applications and services on the .NET framework
- 嵌入式軟件系統測試：基于形式化方法的自動化測試解決方案
- CockroachDB權威指南
- GraphQL學習指南
- Docker進階與實戰
- Ext JS Data-driven Application Design
- 跟老齊學Python：輕松入門
- Nginx Essentials
- 數據結構習題解析與實驗指導
- 微服務架構深度解析：原理、實踐與進階
- MySQL程序員面試筆試寶典
- Bootstrap for Rails
- OpenCV 3計算機視覺：Python語言實現（原書第2版）
- SwiftUI極簡開發
- Secret Recipes of the Python Ninja