Will the performance degrades if a sorter transformation is used - ProProfs Discuss
Advertisement

Will the performance degrades if a sorter transformation is used before aggregator transformation?

Asked by Jeetu_dewda, Last updated: Apr 09, 2024

+ Answer
Request
Question menu
Vote up Vote down

3 Answers

M. Kennedy

M. Kennedy

M. Kennedy
M. Kennedy, Web Content Writer, Denver

Answered Oct 10, 2018

In Informatica, data can be added and then manipulated or sorted based on what the user wants to do. The data can also be mapped showing the data in a useful tool or organizer so that it is easier to read and understand. The sorter transformation takes the data and sorts it by increasing the numbers or decreasing them depending on what you prefer to do. Aggregator transformation also allows the data and numbers to add them up without the user having to do anything.

However, the performance might degrade if the sorter transformation is used prior to the aggregator transformation. Therefore, it is best to use the aggregator transformation first and add the sums of the numbers first before using the sorter transformation.

upvote downvote
Reply 

John Adney

John Adney

John Adney
John Adney

Answered Aug 11, 2017

Sometimes it degrades. It is not thumbrule. Like if we have less data in source, it will be overhead.

upvote downvote
Reply 

John Smith

John Smith

John Smith
John Smith

Answered Mar 17, 2017

No
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.