Data transformation (computing): Difference between revisions

Revision as of 17:07, 29 June 2018

Revision as of 17:09, 10 September 2018

Line 12:

==Data Transformation Process==

Data transformation can be divided into the following steps, each applicable as needed based on the complexity of the transformation required.<br>The Value of Data Transformation

* Data discovery

Line 24:

The steps can be described as follows:

'''Data discovery''' is the first step in the data transformation process. Typically the data is profiled using profiling tools or sometimes using manually written profiling scripts to better understand the structure and characteristics of the data and decide how theit needs to be transformed.

'''Data mapping''' is the process of defining how individual fields are mapped, modified, joined, filtered, aggregated etc. to produce the final desired output. Developers or technical data analysts traditionally perform data mapping since they work in the specific technologies to define the transformation rules (e.g. visual ETL tools,<ref>DWBIMASTER. Top 10 ETL Tools. Retrieved from: http://dwbimaster.com/top-10-etl-tools/</ref> transformation languages).