✍ Kashif M
Trends

Friday, 25 September 2015


Aggregator Transformation Scenarios in Informatica


By on September 25, 2015

Aggregator Transformation In Informatica Scenarios
Aggregator Transformation In Informatica Scenarios



Suppose in our Source Table we have data as given below

 

Aggregator Transformation In Informatica Scenarios
Aggregator Transformation In Informatica Scenarios

We want to load our Target Table as
Aggregator Transformation In Informatica Scenarios
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
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
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
Aggregator Transformation In Informatica Scenarios



Scenario Implementation 2

Source:

Aggregator Transformation In Informatica Scenarios
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.

Kashif
mkashu: Aggregator Transformation Scenarios in Informatica
Review : Kashif | Kashif
Update: September 25, 2015 | Rating: 4.5

Comment for "Aggregator Transformation Scenarios in Informatica"

1 comments:

Blog Archive