Aggregator

[info1976]

Can some advise how I can achieve this functionality in Informatica PC

source
col1
col2
col3
col4

Target
col1
col2
col3

max(source.col1) to target.col1
sum(source.col2) for all col4='x' to tagret.col2
sum(source.col3) for all col4='y' to target.col3

how can I achieve this,
we are generating just one row out of the source and populating the target.
I tried using three aggragitor transformations but could not merge them into onw row.
Any suggestions are highly appreciated

 

[blom0344]

You need only 1 aggregator with expressions like:

max(col1)
sum(col2,col4='x')
sum(col3,col4='y')

If you specify no group by port, then you will end up with 1 row in the target.
So basically, use 1 aggregator with 3 outgoing ports with the mentioned expressions...

Ties Blom
Information analyst