By default the Aggregate Transformation Editor already
groups ProductID when the ProductID is checked.
Using an Aggregate Data Transformation
[ 152 ]
3. Click in the indicated position under the column heading Operation.
This opens the pick list as shown. You may choose any of the items in the list.
For this exercise, the aggregate function SUM will be used.
Chapter 9
[ 153 ]
4. Pick SUM from the list and click the OK button on this editor.
The Aggregate Data Flow item output is now available. The Aggregate
Data Flow item can be used to configure multiple aggregate functions
using the Advanced tab of this editor. For this exercise only, the basic editor
functionality has been used.
Step 5: Add a Percentage Sampling Data
Transformation
The Percentage Data Flow component was described in Chapter 1. This component
just randomly selects a preset percentage of rows of data to pass from its input to
its output path. This component is useful in data mining and wherever you need a
smaller representative set of data from a larger set, for example for testing.
1. Drag and drop a Percentage Sampling Data Flow item from the Data Flow
Transformations group in the Toolbox to the Data Flow page of the canvas.
This adds the Percentage Sampling Data Flow item to the Data Flow page of
the canvas.
Step 6: Establish a Path from Aggregate Data
Transformation to the Percentage Sampling
Data Transformation
1. Right-click the Aggregate Data Flow item and choose Add Path.
Pages:
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118