Basically, incremental aggregation is the process of capturing changes in the source and calculating aggregations in a session. This process incrementally makes the integration service to update targets and avoids the process of calculating aggregations on the entire source.
Upon the first load, the table becomes as below:
On the next load, the data will be aggregated with the next session date.
