This displays the Data Flow window with the "From:" showing Data Source
Reader. The process of establishing a path is same as in the previous chapters.
2. After choosing Aggregate in the "To:" drop-down, click on the OK button in
the Data Flow window.
This opens the Input/Output Selection window where the input, Aggregate
Input1 is displayed.
3. Click on the drop-down arrow for choosing the "Output:". From the list,
choose DataReader Source. Now, click on the OK button.
This establishes the path from the DataReader Source to the Aggregate Data Flow
item. You should be able to see a thin green line from the Data Reader Source to the
Aggregate Data Flow Transformation in the canvas. The input to the Aggregate
Data Flow component is established.
Step 4: Configure the Aggregate Data Flow
Transformation
1. Right-click the Aggregate Data Flow item and from the drop-down choose
Edit??¦.
This opens up the Aggregate Transformation Editor with two panes, a top
pane showing all the columns from the DataReader Source output and a
bottom pane with a list. In the top pane, all columns are unchecked. We are
going to group the ProductID, and in that group we sum the UnitPrice. In
order to do this:
2. Place check marks on the ProductID and UnitPrice columns in the top pane
of the Aggregate Transformation Editor, as shown in the next screenshot.
Chapter 9
[ 151 ]
This adds the two line items to the list in the bottom pane, as shown in the
previous screenshot.
Pages:
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117