Database Reference
In-Depth Information
6. Connect the
TOTAL_SALARY
port to the target, as shown in the following
screenshot:
With this, we are done using the Aggregator transformation. When you use the Aggregat-
or transformation, Integration Service temporarily stores the data in the cache memory.
The cache memory is created because the data flows in a row-wise manner in Informatica
and the calculations required in the Aggregator transformation are column-wise. Unless
we temporarily store the data in the cache, we cannot calculate the result. In the preceding
scenario, the cache starts storing the data as soon as the first record flows into the Aggreg-
