The Data warehouse used some tools. What are the functions?

Data warehouse systems use back-end tools and utilities to populate and refresh their data. These tools and facilities include the following functionsโ€”

1 Data Extraction โ€”

it typically gathers data from multiple, heterogeneous, and external sources.

2 Data Cleaning โ€”

This detects errors in the data and rectifies them when possible.

3 Data Transformation โ€”

It converts data from legacy or host format to warehouse format.

4 Load โ€”

It sorts,, consolidates, computes views, checks integrity. and builds indices and partitions.

5 Refresh โ€”

It propagates the updates from the data sources to the warehouse.

Besides cleaning, loading, refreshing, and metadata definition tools, data warehouse systems usually provide a good set of data warehouse management tools. Data cleansing and data transformation are important steps in improving the quality of the data and, subsequently, of the data mining results.

Leave a Reply

%d bloggers like this: