When using the “in-memory mode” of the Aggregate Action, you can compute several aggregations (i.e. output tables) at the same time. For example, the two following Anatella-Graphs are equivalent but the second one is (at least) two times faster than the first one:
Inside the second graph here above, we used the fact that the Anatella “Aggregate Action” is able to compute several aggregation tables “in parallel”, requiring only one pass over the database to compute all the aggregation tables. This is a unique functionality of Anatella. Thanks to this functionality, the running-time of an Anatella-transformation-graphs containing several aggregations is usually divided by 2 or 3 (or even 4) compared to a standard implementation based on ELT techniques and simple SQL scripts. Anatella delivers you high-performance & ultra-fast computations!