Q: Why can't we use Sorted Input Option for Incremental Aggregation?
Answer: in Incremental Aggregation the Aggregate Calculations are Stored in Historical Caches on the servers. in that Historical Caches the Data is not in Sorted Order(need not be). so even if you pre-sort the incoming records for the particular run, all the data in the historical Cache need not be sorted order. so due to this Reason, Sorted Option is Not Allowed for Incremental Aggregators.
Answer: in Incremental Aggregation the Aggregate Calculations are Stored in Historical Caches on the servers. in that Historical Caches the Data is not in Sorted Order(need not be). so even if you pre-sort the incoming records for the particular run, all the data in the historical Cache need not be sorted order. so due to this Reason, Sorted Option is Not Allowed for Incremental Aggregators.
No comments:
Post a Comment