Technical execution

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
  • Synchronisation 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