The Pivot transform allows you to create new columns out of rows in your input that contain a corresponding set of values.
The Unpivot transform combines multiple columns into a single column with multiple rows (opposite of Pivot).
The Rank transform ranks your data and adds the rank number to your input.
The Top/Bottom transform filters the records to contain the top or bottom 'N' number of records as ranked by the columns you select.
The R Data Generator transform lets you generate data by writing scripts using the R statistical programming language.
The R Language Analysis transform lets you write scripts using the R programming language to perform statistical and predictive analysis on data.
The Remove Duplicates transform lets you remove duplicated records by grouping all of the selected input columns and copying the results to the output.
The Sort transform allows various sorting rules to be applied sort the input data.
The Null Replacement transform allows for the replacing of input data with user-specified values when null values are found.
The Transpose transform lets you turn columns into rows and rows into columns.
The Data Input transform lets you reference a warehouse data storage area containing user input data.
The Python Data Generator transform lets you generate data by writing scripts using the Python programming language.
The Python Analysis transform lets you write scripts using the Python programming language to perform analysis on data.
The Merge transform allows values from two or more columns to be merged into a single column.
The Process Result transform represents the final output or result of the data cube (ETL process).