Back to Top

Conformed Dimensions of Data Quality Blog

Is a Truncated Value Incomplete?

The IT department has just migrated 400,000 accounts from the legacy ERP system onto a new, bright and shiny, system sold by a large software vendor, but the Sales team is mortified. The Sales team has discovered that all of the Sales Notes fields (in addition to others) have been Truncated to 255 characters.

Why Completeness as a First Step

When faced with a number of data quality issues, and urgent stakeholder requests to improve quality, it can be tempting to dive right in and clean the data. This however doesn't get to the root of the problem and one finds that many of the same types of problems have to be resolved over and over again. This can be not only ineffective, but also demoralizing when staff have to spend so much time to get back to where they started.


Subscribe to Conformed Dimensions of Data Quality Blog