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.(Distinct option)
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.
Regards,
Hari Babu
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.(Distinct option)
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.
Regards,
Hari Babu
Wow,I think this is a very good and interesting set of questions about Informatica and other real aspects to look ahead in the future.
ReplyDeleteInformatica Read Rest API
Best Casino Apps In Mississippi - JTHub
ReplyDeleteWith the 출장안마 launch of the casino 파주 출장안마 app in July 2021, Mississippi can offer 정읍 출장샵 its 오산 출장마사지 customers the chance to play the top-notch 통영 출장샵 casino games in the state.