Knowledge of the overall workflow helps you streamline
your data cleansing implementation.
Creating cleansed data is a four-phase and iterative approach as
shown in the following diagram:
- Phase one
- Understand organizational goals and how they determine your requirements
- Phase two
- Understand and analyze the nature and content of the source data
- Phase three
- Design and develop the jobs that cleanse the data
- Phase four
- Evaluate the results
Figure 1. Four phases of data cleansing