It acts very much like a sieve sizing
the grains, or in basic computer terms it is based on the case statement. This was
explained in Chapter 1.
In this present example, our condition for splitting will be based on the value in the
Discount column shown in the previous screenshot. Specifically, we separate out the
data in the table based on those that have a discount > 0 and those that have discount
<=0. These are the Boolean conditions that will be implemented.
1. Drag and drop a Conditional Split Data Flow Transformation from the Data
Flow Transformations group in the Toolbox to the Data Flow page of the
canvas, 'Canvas'.
Step 3: Establish a Path to Connect
DataReader Source with the Conditional Split
Data Transformation
1. Right click the Data Reader Source and from the drop-down click on
Add Path.
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.
When establishing the path is completed, you should be able to see a thin green line
from the Data Reader Source to the Conditional Split transformation in the canvas.
Step 4: Configure the Conditional Split Data
Transformation
1. Right click the Conditional Split component on the canvas and from the
drop-down menu choose Edit??¦.
This opens the Conditional Split Transformation Editor. Read the
instructions in this window. It has three main areas with Variables and
Columns in the left window and some standard core items in the right
window.
Pages:
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109