Current Slide

Small screen detected. You are viewing the mobile version of SlideWiki. If you wish to edit slides you will need to use a larger device.

Extraction, Transformation, and Loading (ETL)

  • Data extraction
    • get data from multiple, heterogeneous, and external sources
  • Data cleaning
    • detect errors in the data and rectify them when possible
  • Data transformation
    • convert data from legacy or host format to warehouse format
  • Load
    • sort, summarize, consolidate, compute views, check integrity, and build indicies and partitions
  • Refresh
    • propagate the updates from the data sources to the warehouse

Speaker notes:

Content Tools

Sources

There are currently no sources for this slide.