PRINCIPLES AND METHODS OF DATA CLEANSING FOR REMOVING ERRONEOUS DATA FROM DATABASE

Now days it’s became universal truth that “To Error is human nature & to forgive, forget is God’s nature”. It means that making error is human right and there is no work done by the human being which is completely and 100% error free. For ex errors made by data entry operator while entering the data, error made at the time of data collections, error made by the researcher at the time sample selection as well as sample selection tools and techniques, some people thinks that errors in data files are acceptable at certain extent but there are some applications where clean data is essentially required where faulty data is never ever acceptable such as, In banking system is not acceptable to deposited or withdrawals money in or from wrong account. This paper is based on the concept about how to avoid dirty and faulty data to get populated in the databases as well as data files