Group By and find maximum

[pavan_test]

Hi All,

I have a input with 3 columns col A, col B and col C

For each of col A and col B combination, I have to write max(col C) to the output.

There can be duplicate data in the columns col A, col B and col C

can someone please let me know how do i achieve this in datastage.

Thanks
pavan

[chulett]

Why not just do it in your source SQL? I'm assuming a database table, of course. Otherwise use the Aggregator to do the exact same thing: group by A & B, maximum(C).