Data Transformation

Data Transformation : The process of defining and applying algorithms to change data from one form or domain value set to another form or domain value set in a target data architecture to improve its value and useability for the information stakeholders. 

[Category=Data Quality ]

Source: Larry English, http://www.iaidq.com/main/glossary.shtml , 22-Jan-2009 13:52

---

These advertisers support this free service

---

Data transformation - Processing that changes the characteristics of data extracted from the operational system; integrates dissimilar data types; changes codes; and selectively calculates, summarizes, and reconciles disparate update cycles.

[Category=Database Management ]

Source: Northwest Database Services, 08 November 2009 09:44:30, http://www.nwdatabase.com/database-glossary-d.htm

---

Data Transformation - The process of redefining data based on some predefined rules, specific formulas, or techniques.

[Category=Data Governance ]

Source: The Data Governance Institute, 28 November 2009 11:16:02, http://www.datagovernance.com/glossary-governance/

---

Data Transformation - The modification of data as it is moved into the data warehouse. This modification can include:

Data Cleansing_ - Part of the Process of Data Quality Assurance

Dimensionalization - Organizing the data into the multidimensional (OLAP) structure of a star schema.

Normalization - Organizing the data into the normal structure of a relational database

Processing Calculations

Changing Data Types

Making the Data More Readable

Replacing Codes with Actual Values

Summarizing the Data by Various Time Periods - See Aggregate / Aggregation

Summarizing the Data in Other Ways - See Aggregate / Aggregation

[Category=Data Warehousing ]

Source: SDG Computing Inc., 07 May 2010 07:45:47, SDG Computing, now offline

---

Data Transformation - in SAS Data Quality_, a cleansing process that applies a scheme to a specified character variable. The scheme creates match codes internally to create clusters. All values in each cluster are then transformed to the standardization value that is specified in the scheme for each cluster.

[Category=Data Quality ]

Source: SAS, 27 May 2010 09:30:26, http://support.sas.com/documentation/cdl/en/dqclref/63101/HTML/default/viewer.htm#/documentation/cdl/en/dqclref/63101/HTML/default/a002282654.htm

---

;Data Transformation - Creating "information" from data. This includes decoding production data and merging of records from multiple DBMS formats. It is also known as data scrubbing or Data Cleansing_. ;;

[Category=Information Management ]

Source: Information-Management.com, 13 June 2010 07:57:31, http://www.information-management.com/glossary/d.html

---

Data Transformation - (1) The formal process of transforming data in the data resource within a common data architecture. It includes transforming disparate data to an integrated data resource, transforming data within the integrated data resource, and transforming disparate data. It includes transforming operational, historical, and evaluational data within a common data architecture. (2) Creating "information" from data. This includes decoding production data and merging of records from multiple DBMS formats. It is also known as data scrubbing or Data Cleansing_.

[Category=Data Warehousing ]

Source: Sun.com, 26 July 2010 08:24:38, http://www.sun.com/third-party/dw/brochures/67198.Acrobat.pdf

---

Data Transformation - Creating "information" from data. This includes decoding production data and merging of records from multiple DBMS formats. It is also known as data scrubbing or Data Cleansing_.

[Category=Data Management ]

Source: DataMentors, 17 August 2010 09:25:55, http://www.datamentors.com/News-and-Resources/Glossary.html

---

Data Transformation - The process of redefining data based on some predefined rules. The values are redefined based on a specific formula or technique. Creating "information" from data. This includes decoding production data and merging of records from multiple DBMS formats. It is also known as data scrubbing or Data Cleansing_.

[Category=Data Warehousing ]

Source: Aexis Business Intelligence, 24 November 2010 08:20:01, http://www.aexis.eu/DataWarehouse-Glossary/

---

Transformations - Used to make non-normal data look more normal.

[Category=Data Quality ]

Source: iSixSigma, 28 February 2011 10:47:02, https:web.archive.org/web/20111109014246/http:www.isixsigma.com/index.php?option=com_glossary