Hi all.
I have a flat file data source with detailed records:
Field1 Field2 Amount
-
1 22 100
1 23 200
2 24 220
3 25 150
3 26 600
I want to get aggregated results by Field1 in my DSO:
Field1 Amount
-
1 300
2 220
3 750
How and there I can do these aggregates during the data load process into DSO?