|
|
 |
|
|
data migration
Data migration extracts, transforms, and loads historical data that resides in legacy systems so that it may be utilized by new enterprise applications.
The purposes of data migration are to:
Ensure historical data accuracy, integrity, consistency, completeness, and validity as required for the new system.
Ensure the historical data gets to the right place in the new system.
Data migration artifacts consists of:
Data Quality Audit - Identifying data quality problems such as accuracy, integrity, consistency, completeness, and validity.
Data Quality Plan - Providing a detailed schedule of events, resources, tools, and dependencies required to ensure data quality (including modifying incorrect values, replacing missing values, merging duplicate records, and decoupling incorrectly merged records).
Data Audit Tools - Generating statistical reports about the content of the data fields (including value counts and frequencies, unique values, missing values, minimum and maximum values, and data types and formats).
Data Migration Map - Charting the source data to the target data model.
Data Migration Plan - Providing a detailed schedule of events, resources, tools, and dependencies required to extract, transform (correcting identified data problems), and load data into the system.
Data Migration Tools - Automating the extraction, transformation, and load of historical data required for the new system.
