Tuesday, 6 January 2015

Data Warehouse Tools and Utilities Functions

The following are the functions of Data Warehouse tools and Utilities:

  1. Data Extraction - Data Extraction involves gathering the data from multiple heterogeneous sources. 
  2. Data Cleaning - Data Cleaning involves finding and correcting the errors in data. 
  3. Data Transformation - Data Transformation involves converting data from legacy format to warehouse format. 
  4. Data Loading - Data Loading involves sorting, summarizing, consolidating, checking integrity and building indices and partitions. 
  5. Refreshing - Refreshing involves updating from data sources to warehouse. 
  6. Note: Data Cleaning and Data Transformation are important steps in improving the quality of data and data mining results.
Posted by at

2 comments:

  1. Alfred Avina31 October 2019 at 03:36

    I had searched for many data warehouse consultant then I found your company to be the most effective service provider.

    ReplyDelete
  2. japhali kasadha29 May 2020 at 02:09

    thanx so much pliz

    ReplyDelete

Subscribe to: Post Comments (Atom)