-->
Transform
Transformation is the processing of data. This includes filtering data, merging data or aggregating data. Transformation is the process that occurs after data is loaded from a source and before data is loaded into the data warehouse. The location where the transformation takes place is the staging area.