Modern Database Management: Chapter 10 Problem and Exercise 3

 

Question

Research some tools that perform data scrubbing. What tool would you recommend for the Fitchwood Insurance Company?

Answer

ETL Tools: Tt is a process to extract information from multiple resources and place it at your data warehouse. So in ETL, we first extract data from numerous sources and then transform this data for logic. We have to apply some business rules and change data logically so we have correct information with us. Finally, we load our data in Teradata. For this Teradata, we can generate our reports easily. Some ETL tools are:

• Informatica Power center

• IBM Data stage

• SAP Business Object

• Microsoft SQL server

• Oracle Data Integrator

Also, You can use winPure there is a clean and match software of it. It has three components DATA, CLEAN, and MATCH.

DATA: importing and exporting of files.

CLEAN: To standardize and correct data.

MATCH: Identity, remove and merge duplicate values in your database;