Skip to Content
0
Former Member
Feb 05, 2008 at 02:00 PM

Aggregate SUM in DSO object

422 Views

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?