OWB provides access to a number of other non-Oracle sources. Connectors for the
E-Business Suite and PeopleSoft provide access to technical and business metadata
and enable inclusion of objects from those ERP applications into mappings and process
flows. The SAP Connector is similar but also includes an ABAP code generator
used to build access to any SAP table on any database, including cluster tables,
through an RFC connection.
For high-speed loading of flat files, Oracle SQL*Loader??™s direct pathload option provides
rapid loading by bypassing the buffer cache and rollback mechanism and
Figure 10-4. Typical Oracle Warehouse Builder mapping validation
Other Software for the Data Warehouse | 241
writing directly to the datafile. You can run SQL*Loader sessions in parallel to further
speed the table-loading process (as many warehouses need to be loaded in a
limited ???window??? of time). Many popular extraction tools, including OWB, generate
SQL*Loader scripts.
Oracle9i first added key ETL functionality in the core database engine, including
support for external tables, table functions, merge (i.
Pages:
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531