Extraction, Transformation, and Loading
Oracle Warehouse Builder (OWB) is a tool used in the design of target databases,
especially data warehouses, and provides a metadata repository. However, it is best
known as a GUI-based tool used in building source-to-target maps and for generating
extraction, transformation, and loading (ETL) scripts. OWB leverages key
embedded ETL features in the Oracle database first made available in Oracle9i.
OWB is included with the Oracle database as of Oracle Database 10g Release 2. We
describe it further in Chapter 10.
Optionally, Oracle also offers a data integration tool, Oracle Data Integrator (ODI),
that is not as Oracle database-centric as OWB (although the Oracle database can be
a source and/or target). Oracle Data Integrator is based on a product and company
that Oracle acquired named Sunopsis. In addition to providing ETL capabilities,
ODI can generate code as web services for SOA deployment and is a key part of Oracle??™s
SOA integration strategy.
20 | Chapter 1: Introducing Oracle
Database Performance Features
Oracle includes several features specifically designed to boost performance in certain
situations.
Pages:
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76