Aggregator Transformation in Informatica - Shikshaglobe

Content Creator: Vijay Kumar

What is Aggregator Transformation?

Aggregator change is a functioning change utilized to perform total computations like total, normal, and so forth.

For instance, if you need to work out the number pay rates of all representatives division-wise, we can utilize the Aggregator Transformation.

The total tasks are performed over a gathering of columns, so a transitory placeholder is expected to store this large number of records and play out the estimations.

For this, aggregator reserve memory is utilized. This is a transitory primary memory that is distributed to the aggregator change to perform such tasks.

In this model, we will compute the number of compensations division-wise. For this, we require another segment to store this aggregate. Thus, most importantly, we will set up another section.


Stage 1 - Create another information base objective table, for instance, say "sum_sal_deptwise", utilizing the beneath script. You will see the new data set target table is made under the Target envelope in the following stage.

Download the above Create_table_sal_deptwise.txt File


Stage 2 - Create a New planning "m_ sum_sal_deptwise".

To make new planning, we really want source table (EMP) and target table (sum_sal_deptwise) both in planning creator for that we really want to

Import the objective table "sum_sal_deptwise" in the planning.

Import the source table "emp".


Stage 3 - In the planning,

From the Source Qualifier, erase the segments empno, ename, work, mgr, hire date, and comm so leaving just the sections deptno and sal.

Make another aggregator change involving the tool compartment menu as displayed in the screenshot. At the point when you click on the aggregator symbol, another aggregator change will be made.


Stage 4 - Drag and drop SAL and DEPTNO sections from the source qualifier (SQ_EMP) to the aggregator change

Stage 5 - Double snap on the aggregator change to open its properties, and afterward

Add another port in the change

Rename the port name to SUM_SAL

Change the information sort of this new port to twofold

Make this port a result port by choosing the checkbox of the result port.

Click on the articulation choice

Stage 6 - In the articulation window

Add articulation sum(SAL), you need to compose this articulation.

Select the Ok Button, this will bring back the alter change window.

Stage 7 - In alter change window, select the choice "GroupBy" by denoting the actually look at box against the deptno segment and Click Ok ( by choosing bunch by against the deptno, we are educating Informatica to bunch compensations by deptno)

Stage 8 - Link the deptno and sum_sal segments from aggregator change to the objective table

Presently save the planning and execute it subsequent to making another meeting for this planning. The objective table would contain the number of pay rates division-wise. Along these lines, we can utilize aggregator change to compute total outcomes.

Tags:

aggregator transformation in informaticasorted input in aggregator transformation in informaticagroup by in aggregator transformation in informaticahow to improve performance of aggregator transformation in informaticacount function in aggregator transformation in informaticasorter and aggregator transformation in informaticaincremental aggregator transformation in informaticahow to use aggregator transformation in informaticahow to remove duplicates using aggregator transformation in informaticalimitations of aggregator transformation in informaticadifference between expression and aggregator transformation in informaticajoiner transformation in informatica active or passivejoiner transformation in informatica master and detailaggregation without aggregator transformation in informaticajoiner transformation in informatica bdmaggregator transformation in informatica without group byaggregator transformation in informatica bdmaggregator transformation in informatica cloudaggregator transformation in informatica countjoiner transformation in informatica cloudaggregator transformation cache in informaticahow to create aggregator transformation in informaticacount in aggregator transformation informaticajoiner transformation in informatica developerjoiner transformation in informatica data qualityaggregator transformation to remove duplicates in informaticaaggregator transformation in informatica developerjoiner transformation in informatica exampleexample of aggregator transformation in informaticafirst and last functions in aggregator transformation in informaticaaggregator transformation functions in informaticaaggregator transformation in informatica folks talkaggregator transformation in informatica exampleuse of aggregator transformation in informaticawhy aggregator transformation is active in informaticaaggregator transformation in informatica group byjoiner transformation in informatica guru99joiner transformation in informatica tutorial gatewayhow does aggregator transformation work in informaticaaggregator transformation in informatica guru99how to tune aggregator transformation in informaticahow to use count in aggregator transformation in informaticaaggregator transformation in informatica interview questionsjoiner transformation in informatica interview questionsjoiner transformation in informatica iicsjoiner transformation in informatica sorted inputwhat is aggregator transformation in informaticainterview questions on aggregator transformation in informaticaaggregator transformation in informatica jobaggregator transformation in informatica jdbcaggregator transformation in informatica javaaggregator transformation in informatica joineraggregator transformation in informatica jobs in usaaggregator transformation in informatica join typeaggregator transformation in informatica joinaggregator transformation in informatica join usingaggregator transformation in informatica join 2aggregator transformation in informatica kbaggregator transformation in informatica kafkaaggregator transformation in informatica kpiaggregator transformation in informatica knowledge baseaggregator transformation in informatica kubernetesaggregator transformation in informatica keys to be descendingjoiner transformation limitations informaticaaggregator transformation in informatica networkaggregator transformation in informatica not workingaggregator transformation in informatica nodeaggregator transformation in informatica netappaggregator transformation in informatica newlookuprow valuesaggregator transformation in informatica normal joinaggregator transformation in informatica null valuesaggregator transformation in informatica not sortedaggregator transformation in informatica non group by portsaggregator transformation in informatica nulloutput of aggregator transformation in informaticajoiner transformation in informatica performance tuningjoiner transformation in informatica powercenterjoiner transformation informatica power centeraggregator transformation properties in informaticaperformance tuning of aggregator transformation in informaticaproperties of aggregator transformation in informaticaaggregator transformation in informatica powercenteraggregator transformation in informatica performanceaggregator transformation ports in informaticaaggregator transformation in informatica scenariostransformation scope in aggregator informaticajoiner transformation in informatica folks talkaggregation without using aggregator transformation in informaticaaggregator transformation in informatica valueaggregator transformation in informatica vsaggregator transformation in informatica viaggregator transformation in informatica vimaggregator transformation in informatica v2aggregator transformation in informatica vs ssisaggregator transformation in informatica vs talendaggregator transformation in informatica vs mulesoftaggregator transformation in informatica variable portaggregator transformation in informatica with examplejoiner transformation in informatica with examplewhat is the use of aggregator transformation in informaticaaggregator transformation in informatica with group byaggregator transformation in informatica xpathaggregator transformation in informatica xmlaggregator transformation in informatica xml fileaggregator transformation in informatica youtubeaggregator transformation in informatica yamlaggregator transformation in informatica youtube videoaggregator transformation in informatica youtube channelaggregator transformation in informatica zapieraggregator transformation in informatica zscaleraggregator transformation in informatica zshaggregator transformation informaticaaggregator transformation in idq