15_-_Use_of_Aggregator_Transformation in Informatica

View this thread on: d.buzz | hive.blog | peakd.com | ecency.com
·@ashish.sharma·
0.000 HBD
15_-_Use_of_Aggregator_Transformation in Informatica
<center><a href='https://dtube.video/#!/v/ashish.sharma/7ysfxedc'><img src='https://scrappy.i.ipfs.io/ipfs/QmVW4uWjZ2R42CBL1U3MZM12bXSyHcbGEvK9WRSNA5RvvX'></a></center><hr>Aggregator transformation is an active transformation is used to performs aggregate calculations like sum, average, etc.

For example, if you want to calculate the sum of salaries of all employees department wise, we can use the Aggregator Transformation.

The aggregate operations are performed over a group of rows, so a temporary placeholder is required to store all these records and perform the calculations.For this, Aggregator cache memory is used. This is a temporary main memory which is allocated to the aggregator transformation to perform such operations.<hr><a href='https://dtube.video/#!/v/ashish.sharma/7ysfxedc'>► Watch on DTube</a><br /><a href='https://dtube2.gateway.ipfsstore.it:8443/ipfs/QmNm1bf8drQbCcVm2L5dempfEoptM7NBn3CvMfRq4zXK6e'>► Watch Source (IPFS)</a>
👍 , , , ,