The Sorter transformation is used in ETL mappings to sort or arrange input rows in ascending or descending order based on one or more specified columns. Source Qualifier extracts data, Expression calculates values, and Sequence Generator produces numbers, making them incorrect for sorting data.