A business intelligence system typically provides a consolidated view across the enterprise. Use this session to learn how to design data flows that move data from source systems into your target environment you can use Warehouse Builder Extract, Transform and Load (ETL) features.
Level:
Basic
Coverage:
Versions 9.0.4, 9.2, 10g
Publication:
Online and hands-on
Intended audience:
Users who want to start using Warehouse Builder for data movement.
Business intelligence architects, who want to learn Warehouse Builder's ETL terminology.
Objectives
Learn Warehouse Builder's terminology for ETL.
Be able to design an ETL process with more than one data source into one target.
Learn about the Toolbox and the most commonly used operators.
Pre-requisites
Be familiar with the Warehouse Builder concepts.
Content
Data flows represent the individual Extract, Transform and Load (ETL) processes. Warehouse Builder uses the term mapping to refer to a data flow. The materials below teach you the basics of how to design mappings.
Component
Version
Estimated Duration (h)
Delivery
Availability
Watch the Warehouse Builder ETL recorded demo online*
9.0.4 / 9.2 / 10g
0:10
March 2004
Go through Demo 3 - ETL Demo - in the hands-on demo**
9.0.4
0:30***
March 2004
9.2 / 10g
0:30***
March 2004
* Note: you may have to disable your popup blocker in order to view the recorded demo.
** Note: you may want to go through the OWB self-service
education - installation session on how to setup Warehouse Builder.
*** Note: excluding setup, included in the demo document. Legend: = recorded, = online, = paper, = hands-on
Bookmark
= online, 
= paper, 
