Raj,
Thanks for your reply. I was also thinking that an order by will definitely be faster than a sorter transform. But, in my project we are using sorter transform's since the sort engine that they use are better than the aggregator sorting the records! If not too much of a hassle can you...
Hi,
I wanted to know which is more efficient, to sort data using a sorter transformation in Informatica before aggregating the data or to use an Order by in the source qualifier override?
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.