Data migration from one legacy system to a new system pose many challenges. Out of all the migration projects a big percentage ( 83% ) of projects either fail or exceed timescales. The main reason for high failure rate is due the poor quality of data in legacy systems.
Here are the common issues rising out of data migration project.
- Incorrect data in the system
- Partial data or missing data (If a record has six fields and some of them are empty)
- Duplicate data
- Redundant data (data no longer valid)
- Superseded data (old data)
- Inconsistent data (e.g. Mark NW; Mark N.W.; N.W. Mark)
- Incorrect data codes (e.g. Male = 'M', 'Male' or '1')
- Incorrect data format, not confirming with the business rule
- Cumulative errors in data due to incorrect data processing
JDE user list has tie-up with major data cleansing firms to get rid of your data from such gross irregularities. During this process we detect, remove and correct data in your existing system. The objective of data cleansing is to provide comprehensive care of your data and enable you to achieve full worth form CRM or ERP application.
To know more about business data cleansing or data hygiene process, please contact us with your requirement.
1 comments:
I am no wizz kid on databases, your article is great as it opens my eyes to some of the mistakes on database designs etc.
Post a Comment