Guest jimmi123 Posted November 3, 2011 Report Share Posted November 3, 2011 If you own a business, you must understand the importance of Data Cleansing Services to get rid of corrupt data from the company's customer and business database. Data cleansing is a procedure where incomplete, inaccurate and irrelevant data gets deleted or removed ensuring that your data is correctly formatted, and is accurate and consistent. If you have inaccurate mail addresses, your mail might go to the postal service dumpsters, leading a huge loss for your mailing campaign. Data cleansing services are now a significant business in the database world. Data cleansing ensures that undecipherable data does not enter the data warehouse. Undecipherable data will affect reports generated from the data warehouse via OLAP, Data Mining and KPI's. Most data warehousing projects experience delay and budget overruns due to unforeseen circumstances relating to data cleansing, thus data cleansing is extremely important part. It is important is start mapping out the data that will be entered into the data warehouse as early as possible. This may change as the project matures but the documentation trail will come in extremely valuable as you will need to obtain commitments from data owners that they will not change data formats without prior notice. Create a list of data that will require Extracting, Transforming and Loading. Create a separate list for data that has a higher likelihood of changing formats. Decide on whether you need to purchase ETL tools and set aside an overall budget. Obtain advice from experts in the field and evaluate if the product fits into the overall technical hierarchy of your organization. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.