Master Data Management - Methodology
Analyze legacy
- Activities to identify data source, required data, data structure, data relation, condition logic from legacy system with technical and functional users
-
To confirm
- The object list, templates of data migration
- Type of data: master or transaction data
- Data structure, relation and condition of each tables
- Scope of historical data
- the list of master value or meta-data
- the transformation logic for obsolete data
Data validation and conversion
-
Activities to create tools to detect or revise unclean data from legacy system
- Gather all validation rules from users
- Confirm the revising solution for unclean data
- Create validation and conversion tools which able to detect or revise unclean data automatically based on rules
- Perform test scenario with dummy data
Extract, transform, load process
- To extract data from legacy system and share it to user to review and correct data
- Transform data is activity of revising or cleaning the original data via validation or conversion tools before migrate into destination system
- Load data into new system including pre and post validation between clean data file and extracted file to ensure that data are migrated completely and correctly