Many organizations are in the process of replacing
legacy systems, implementing corporate management
applications such as enterprise resource planning
(ERP) and customer resource management (CRM), executive
information and decision support systems, or data
warehouses and other consolidated databases.
A critical element of any new systems initiative
is to first understand the quality of data in each
source, then to ensure the quality and integrity of
the resultant data. Data should be validated at key
points throughout the transformation process, to prevent
corruption, truncation, improper mapping or defects
resulting from potential flaws in transformation logic.
Further, the development of transformation solutions
presents an opportunity for organizations to improve
data quality on an ongoing basis with a pro-active,
systematic approach that allows for periodic validation,
monitoring and certification.
Certica Solutions provides software and a step-by-step
methodology for data quality validation and monitoring—before,
during and after transformation. As source systems
are prepared for transformation, Certify™
software will:
- Present detailed information about the data issues
that need to be dealt with when drawing on data
from each source system, and provide an objective
comparison of sources when the same data is captured
in multiple locations.
- Ensure compliance with both simple data validations
and complex business rules.
- Uncover business rules in legacy data that may
not be well understood.
- Aid in the accurate mapping and integration of
data from disparate systems.
At key points during and after the migration and
transformation process, data should be validated to
ensure that it has not been truncated, improperly
mapped, incorrectly transformed or otherwise corrupted.
In addition to alerting programmers and analysts of
potential problems, thorough data validations help
to protect the investment in new systems initiative.
|
