Data Extraction and Cleaning Tools Oracle Tips by Burleson Consulting

The Data Warehouse Development Life Cycle

Online Analytical Processing and Oracle

Data Warehouses And Multidimensional Databases

* Data extraction tools—Tools to retrieve from different hardware and database platforms, resulting in a common format flat files.

* Metadata repository--Holds common data definitions, and data definitions that have changed over time.

* Data cleaning tools--Tools for ensuring uniform data quality, and converting non-uniform data such as international currencies to dollars.

* Data sequencing tools--RI rules for the warehouse that enforce business rules.

* Warehouse loading tools--Tools for populating the data warehouse, such as SQL*Loader.

---

This is an excerpt from "High Performance Data Warehousing". To learn more about Oracle, try "Oracle Tuning: The Definitive Reference", by Donald K. Burleson.  You can buy it direct from the publisher at 30% off here:
http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm