Deriving a newly calculated value (e.g., sale amount = qty * unit price)
Joining together data from multiple fields
Generating surrogate key values
Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)