top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Why cannot we use sorted input option for incremental aggregation?

+1 vote
679 views
Why cannot we use sorted input option for incremental aggregation?
posted Jul 17, 2013 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

In incremental aggregation, the aggregate calculations are stored in historical cache on the server. In this historical cache the data need not be in sorted order. If you give sorted input, the records come as presorted for that particular run but in the historical cache the data may not be in the sorted order. That is why this option is not allowed.

answer Jul 18, 2013 by Shatark Bajpai
...