What is Data Transformation ?
Ans). Transformation is the process that converts data to a required definition and value.
Because the data in a data warehouse comes from many sources, the data may be in different formats or be inconsistent. Data is transformed using routines based on a transformation rule, for example, product codes can be mapped to a common format using a transformation rule that applies only to product codes.
After data has been transformed it can be loaded into the data warehouse in a recognized and required format.