A transformation where each record in an input stream is converted to many records in the appropriate table in the data warehouse. This is particularly important when taking data from nonrelational databases.
Changing the arrangement of the rows and columns in a tabular report, where frequently the row or column headings are derived from distinct attributes in the data itself.