Warehouse transformers are stored procedures and user-defined functions that you can use to transform data in a warehouse step. In the Data Warehouse Center, you use steps to create and maintain a warehouse. Steps control how data is transformed into meaningful business information. You can use warehouse transformers in a step to clean, invert, and pivot data; generate primary keys and period tables; and calculate various statistics.