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.

The Aggregator Transformation is a crucial building block within Informatica PowerCenter. It specializes in data summarization and aggregation, allowing you to perform calculations on groups of data rows, thereby reducing the data volume while preserving essential information.

Your gateway to success

Key Functions of Aggregator Transformation

The Aggregator Transformation offers a wide range of functions, including:

  • Summarization: It can perform calculations like sum, average, count, maximum, and minimum on grouped data.
  • Grouping: You can group data based on specific attributes, enabling you to perform aggregations on distinct categories within your dataset.
  • Expression Evaluation: It allows the evaluation of complex expressions involving data columns.
  • Sorted Input: Aggregator Transformation often requires sorted input data, which ensures accurate results. Informatica handles this sorting internally for efficiency.

    must read---

Configuration and Usage

Configuration Steps

To use the Aggregator Transformation effectively, you need to:

1.     Define Grouping: Specify which columns will be used for grouping data. This is crucial for determining how the data will be segmented for aggregation.

2.     Aggregation Expressions: Define the aggregation expressions you want to apply to the grouped data. For example, you can calculate the total sales per product category.

3.     Output Ports: Create output ports for the aggregated results. These ports will store the calculated values.

Click here to explore

Use Cases

The Aggregator Transformation is versatile and finds applications in various scenarios:

  • Financial Analysis: It can be used to calculate financial metrics like total revenue, average profit, or maximum transaction value for each customer or product.
  • Data Cleansing: You can use it to identify duplicate records within a dataset based on specific attributes.
  • Time-Based Aggregations: For time-series data, you can perform aggregations such as calculating hourly or daily averages.

    Click here for details

Performance Considerations

Efficiency is key when working with the Aggregator Transformation:

  • Sorted Data: Ensure that your input data is sorted correctly. If not, use the Sorter Transformation before the Aggregator to achieve the required order.
  • Filtering: Minimize the data sent to the Aggregator by filtering out unnecessary records earlier in the workflow.
  • Cache Size: Adjust the cache size appropriately based on your dataset's volume to optimize memory usage.

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".

See also here -->>

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

See also here -->>

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.


Read More :

Router Transformation in Informatica
Aggregator Transformation in Informatica
Source Qualifier Transformation in Informatica
Introduction to Transformations in Informatica and Filter Transformation

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

Featured Universities

Mahatma Gandhi University

Location: Soreng ,Sikkim , India
Approved: UGC
Course Offered: UG and PG

MATS University

Location: Raipur, Chhattisgarh, India
Approved: UGC
Course Offered: UG and PG

Kalinga University

Location: Raipur, Chhattisgarh,India
Approved: UGC
Course Offered: UG and PG

Vinayaka Missions Sikkim University

Location: Gangtok, Sikkim, India
Approved: UGC
Course Offered: UG and PG

Sabarmati University

Location: Ahmedabad, Gujarat, India
Approved: UGC
Course Offered: UG and PG

Arni University

Location: Tanda, Himachal Pradesh, India.
Approved: UGC
Course Offered: UG and PG

Capital University

Location: Jhumri Telaiya Jharkhand,India
Approved: UGC
Course Offered: UG and PG

Glocal University

Location: Saharanpur, UP, India.
Approved: UGC
Course Offered: UG and PG

Himalayan Garhwal University

Location: PG, Uttarakhand, India
Approved: UGC
Course Offered: UG and PG

Sikkim Professional University

Location: Sikkim, India
Approved: UGC
Course Offered: UG and PG

North East Frontier Technical University

Location: Aalo, AP ,India
Approved: UGC
Course Offered: UG and PG