This opens the Data Flow window displaying the "From:" as an Aggregate
data flow item.
2. Click on the drop-down arrow head in the "To:" window.
In the drop-down, you will see three options, DataReader Source,
Aggregate, and Percentage Sampling.
3. Choose Percentage Sampling. Click on the OK button in the Data
Flow window.
This establishes the path from the Aggregate Data Flow Item to the Percentage
Sampling Data Flow item, and you will be seeing a thin green line connecting
the two.
Using an Aggregate Data Transformation
[ 154 ]
Step 7: Configure the Percentage Sampling
Data Flow Item
1. Right-click Percentage Sampling Data Flow item in the canvas and choose
Edit??¦.
This opens the Percentage Sampling Transformation Editor as shown in the
next screenshot.
2. Read the instructions on this window. Change Percentage of rows: to 25 and
use the default Random seed by checking the Use the following random
seed: checkbox in the above window. Click on the OK button.
When you place a check mark, a little message window opens below the random
seed drop-down describing under what conditions it will be desirable to use a
random seed. You will be using the default. This completes the editing of the
Percentage Sampling Data Flow item.
Chapter 9
[ 155 ]
Step 8: Add a Recordset Destination Data
Flow Component
We will add a Recordset Destination Data Flow component to the canvas and
connect the output of the Percentage Sampling Data Flow item to the input of the
Recordset Destination.
Pages:
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119