For example, you multiply price and quantity
column values to produce a total price column.
Export Column
Data read during data flow can be directed to a file. Product information components
such as a graphics, other product information, or a drawing, can be directed to a file
where it gets stored. For this transformation, only specific SSIS data types are used,
such as??”DT_TEXT, DT_NTEXT, or DT_IMAGE, as it is specifically used to divert images
and documents.
SSIS Basics
[ 18 ]
Fuzzy Grouping
This transformation is mostly used in data cleansing, by separating duplicate data
and assigning a marker to show how data is duplicated with reference to a chosen
row (called a canonical row). Departures from the exact match are scored, but it does
not remove duplicates. For each input row in data, three additional columns are
produced after processing, which are: indicating the location of the row, identifying
a group of rows which may contain duplicates, and score showing the goodness
of match.
Fuzzy Lookup
This transformation, unlike lookup transformation, uses fuzzy matching. It is not
used for locating exact matches, but for locating close matches in the data flow.
Fuzzy matching is carried out against a reference data source in SQL Server table.
Again, there are restrictions on data type for using this transformation being limited
to DT_WSTR, and DT_STR.
Import Column
This transformation reads data from files and adds it to database columns.
Pages:
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36