Basic ETL, or Core ETL:
It provides the essential building blocks for building data warehouse ETL solutions on the Oracle database. In general, the Basic ETL feature set is a superset of Warehouse Builder’s 10.1 release’s capabilities.
It extends Warehouse Builder to a full-featured data warehouse-centric design and data integration tool, integrated with Oracle’s Business Intelligence tools (Oracles Discoverer and Oracle’s Business Intelligence Enterprise Edition).
It provides data profiling, data cleansing and data governance features tailored around the data quality issues associated with ETL, data warehousing, and business intelligence, and integrated with the rest of your Warehouse Builder design and ETL metadata.
Provide business-level views of data from ERP applications to eliminate the need to design ETL around obscurely named base tables.