Technical execution
1. Analyses and planing
- Definition of data requirements and targets
- Analyse the current situation, discover potneital data issues
- Plan the data cleansing approach
2. Restructuring
- Check field values
- Split field values if required
- Correct field values
- Harmonise field values
- Relationalising the databases
3. Upper/lower case transformation
- Uppercase notation will be converted into mixed upper/lower case notation. “JBS JENAER BUEROSYS LTD” becomes “JBS Jenaer Bürosys Ltd”
4. Postal corrections (national | international)
- Correction of false written street and city/town and county names, state names
- Synchronization of postcode, town and street
- Generation of missing post codes
5. Duplicate-cleansing
- Duplicate addresses will be dicsovered using a method of similarity even notation is different
- Generation of allocation maps
6. Data migration
- The cleansed data will be migrated into the data model of the target system