S No |
Transformation |
Description |
1 |
Aggregate |
Aggregates and groups values |
2 |
Audit |
Adds audit information |
3 |
Character Map |
Applies string operations to character data |
4 |
Conditional Split |
Evaluates and splits up rows |
5 |
Copy Column |
Copies a column |
6 |
Data Conversion |
Converts data to a different data type |
7 |
Data Mining Query |
Runs a data mining query |
8 |
Derived Column |
Calculates a new column from existing data |
9 |
Export Column |
Exports data from a column to a file |
10 |
Fuzzy Grouping |
Groups rows that contain similar values |
11 |
Fuzzy Lookup |
Looks up values using fuzzy matching |
12 |
Import Column |
Imports data from a file to a column |
13 |
Lookup |
Looks up values in a dataset |
14 |
Merge |
Merges two sorted datasets |
15 |
Merge Join |
Merges data from two datasets by using a join |
16 |
Multicast |
Creates copies of a dataset |
17 |
OLE DB Command |
Executes a SQL command on each row in a dataset |
18 |
Percentage Sampling |
Extracts a subset of rows from a dataset |
19 |
Pivot |
Builds a pivot table from a dataset |
20 |
Row Count |
Counts the rows of a dataset |
21 |
Row Sampling |
Extracts a sample of rows from a dataset |
22 |
Script Component |
Executes a custom script |
23 |
Slowly Changing Dimension |
Updates a slowly changing dimension in a cube |
24 |
Sort |
Sorts data |
25 |
Term Extraction |
Extracts data from a column |
26 |
Term Lookup |
Looks up the frequency of a term in a column |
27 |
Union All |
Merges multiple datasets |
28 |
Unpivot |
Normalizes a pivot table |