It includes tools for extracting data from multiple operational
databases and external sources; for cleaning, transforming
and integrating this data; for loading data into the data
warehouse; and for periodically refreshing the warehouse to
reflect updates at the sources and to purge data from the
warehouse, perhaps onto slower archival storage.