 |
| Aggregator Transformation In Informatica Scenarios |
Suppose in our Source Table we have data as given below
 |
| Aggregator Transformation In Informatica Scenarios |
We want to load our Target Table as
 |
| Aggregator Transformation In Informatica Scenarios |
Describe your approach.
Answer:
Here our scenario is to convert many rows to one row, and the transformation which will help us to achieve this is Aggregator.
Our Mapping will look like this:
 |
| Aggregator Transformation In Informatica Scenarios |
We will sort the source data based on STUDENT_NAME ascending followed by SUBJECT ascending.
 |
| Aggregator Transformation In Informatica Scenarios |
Now based on STUDENT_NAME in GROUP BY clause the following output subject columns are populated as
MATHS: MAX( MARKS, SUBJECT = ’Maths’ )
LIFE_SC: MAX( MARKS, SUBJECT = ’Life Science’ )
PHY_SC: MAX( MARKS, SUBJECT = ’Physical Science’ )
 |
| Aggregator Transformation In Informatica Scenarios |
Scenario Implementation 2
Source:
 |
| Aggregator Transformation In Informatica Scenarios |
The expected output data: 100 XYZ AAA BBB CCC Which transformations are used for this?
Answer:
Use an Aggregator transformation with variable.
Awesome article thanks for sharing.
ReplyDelete