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