What are some of the errors and inconsistencies in data that the cleansing process is looking to rectify?
What will be an ideal response?
There are many errors and inconsistencies in data which the cleansing process needs to take care of. Some of these are:
- misspelled names and addresses
- old formats for addresses
- impossible or invalid dates of birth
- fields used for purposes not intended
- missing data
- mismatched addresses
- duplicate data
- different primary keys across sources
Business
You might also like to view...
When lenders use the term "debt-income ratio," they are referring to:
A: A requirement of the federal government; B: A loan qualifying tool; C: A formula used in appraising the property; D: Part of the closing costs.
Business
The United States has a high-context culture
Indicate whether the statement is true or false
Business