1. What is a sorter transformation?
Sorter
transformation is used to sort the data. You can sort the data either
in ascending or descending order according to a specified sort key.
2. Why sorter is an active transformation?
As sorter transformation can suppress the duplicate records in the source, it is called an active transformation.
3. How to improve the performance of a session using sorter transformation?
Sort
the data using sorter transformation before passing in to aggregator or
joiner transformation. As the data is sorted, the integration service
uses the memory to do aggregate and join operations and does not use
cache files to process the data.
No comments:
Post a Comment