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:
|
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:
Performance Considerations
Efficiency is key when working with the Aggregator
Transformation:
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
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.
Router Transformation in Informatica |
Aggregator Transformation in Informatica |
Source Qualifier Transformation in Informatica |
Introduction to Transformations in Informatica and Filter Transformation |