with capitalized first letter can be generated, while the input
comes in with arbitrary cases. You will find an example in Chapter 5.
Conditional Split
Routing the data conditionally to outputs, based on a given criteria is sometimes
needed. For example it is possible to sort out a list and fill items A to M in one table
and N to Z in another table, etc. You will find an example in Chapter 8, based on this.
Copy Column
This transformation copies a column to a new column to which you may attach other
transformations such as aggregate, character map, etc.
Data Conversion
Data type mismatch is not an uncommon source of error during transformation
while extracting from data sources, or loading data to target databases. Data
truncation errors in strings as well as numbers are possible. Error outputs can be
used to divert mismatched items to a different location, which can be looked at more
closely and modified. You will find an example in Chapter 10.
Data Mining Query
This transformation is really a task that is used in conjunction with Analysis Services.
DMX or Data Mining Extensions language is used to obtain results in the form of a
single data value, or a data set, by running a query against Analysis Services data by
connecting to Analysis Services or to an Analysis Services project.
Derived Column
As the name implies, you can create a new column by combing columns, or by
applying mathematical expressions to values in columns, or populating a column
with a part of data in a column.
Pages:
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35