MIRACLE WISDOM - EXTRACTING, TRANSFERRING, TRANSFORMING, AND LOADING DATA - ETTL
In data transformation, the data is formatted, so that it can be accepted in the data warehouse.
For example, an entity with multiple names (such as AT&T, ATT, or Bell) must be converted into an entity with a single name (such as AT&T).