Parallel direct path loading and unloading
are supported.
Each of these database features is typically used for high-performance data transfers and
not (by themselves) for difficult transformations. Oracle Warehouse Builder (OWB) is
the Oracle database??™s ETL tool used for building maps from extraction sources, through
predefined or custom transformations to target tables. OWB then can be used to automatically
generate the scripts needed to perform the ETL. More than just an ETL tool,
OWB also can be used as a data warehouse design tool and provides a metadata repository.
Designs may also be imported from a variety of design tools such as Oracle
Designer, CA??™s ERwin, Sybase PowerDesigner, and Business Objects Designer.
In most warehouse building, metadata is first imported that describes source tables,
including Oracle (via database links) and other RDBMS systems (through ODBC or
gateways) and flat files. Target tables are designed or imported, and source metadata
is mapped to target metadata, including transformations.
Pages:
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529