Part II

Performing ETL

Oracle Warehouse Builder enables you to perform Extract, Transform, and Load (ETL) operations. You can choose among different methods of transforming source data before loading it into your data warehouse. This part discusses deploying data and ETL objects and data auditing.

This part contains the following chapters:

• Chapter 4, "Overview of Transforming Data"

• Chapter 5, "Creating PL/SQL Mappings"

• Chapter 6, "Performing ETL Using Dimensional Objects"

• Chapter 7, "Using SQL*Loader, SAP, and Code Template Mappings"

• Chapter 8, "Designing Process Flows"

• Chapter 9, "Defining Custom Transformations"

• Chapter 10, "Understanding Performance and Advanced ETL Concepts"

• Chapter 11, "Scheduling ETL Jobs"

• Chapter 12, "Deploying to Target Schemas and Executing ETL Logic"

• Chapter 13, "Auditing Deployments and Executions"

• Chapter 14, "Managing Metadata Dependencies"

• Chapter 15, "Troubleshooting and Error Handling for ETL Designs"

• Chapter 16, "Creating and Consuming Web Services in Oracle Warehouse Builder"

• Chapter 17, "Moving Large Volumes of Data Using Transportable Modules"