|
DATA TRANSFORMATION | ||||||||
Data Transformation is the conversion of data from its existing format or structure to any number of different formats or structures. Data transformation is used to 'massage' the data in a source system to make it suitable for use at it's destination. Transformation can be as simple as providing a data file for import into a Microsoft Excel spreadsheeet, or involve greater complexity such as the scheduled extraction and standardisation of data from numerous enterprise operational systems in prepration for cross-system financial reconciliation.
The functions performed during data transformation tend to change over time as data in the underlying systems evolves in line with business needs. A data transformation toolset is used to replace the laborious and risk-prone task of writing and maintaining custom software to undertake once-only or periodic transformations. | ![]() |
|
Business Applications for Transformation
|
Data Transformation Services
|