Oracle warehouse builder includes the following components:
1. ETL can basically meet most functions. The license of this component is included in 9i/10g Enterprise Edition.
2. Data quality. This component must be purchased separately and only available from 10 GB
3. connector (connect to SAP/PeopleSoft ). This component must be purchased separately and only available from 10 GB
4. Advanced functions such as scheduler. This component must be purchased separately and only available from 10 GB
Oracle Data Mining:
1. Oracle's data mining functions can be used in the Enterprise Edition, but do not contain commercial licenses. License licenses must be purchased for all versions (the price is about 50% of DB)
2. This is true for other features such as partition, RAC, OLAP, and spatial. This feature is available in the Enterprise Edition, but must be purchased separately for commercial licenses.
Oracle does not recommend that you use the CDC function in 9i. We recommend that you use the CDC function from 10 Gb. If you use 9i, the CDC may be suspended, resulting in incorrect data retrieval. In 9i, you can only use music videos to obtain data.