Chapter 5, Problem 6RQ

Explanation of Solution

Data cleansing:

The process of detecting, correcting or deleting incomplete, incorrect, inaccurate records in a database is called as data cleansing.

• It is a step in the data reconciliation process.
• In this step, the problems or the errors in the data are identified and rejected.
• Then, to fix the errors, the flag message is sent back to the source.

Common tasks in data cleansing:

• The data are decoded in the way such that it suits the form of the data warehousing applications.
• Breaking the text fields into its constituent parts...