The program accesses the source database link, performs the transformations defined in the mappings, and loads the data into the target table. The internet has changed everything, including data warehouses. The Web provides a new source for capturing customer information. OWB can address all of these sources with its built-in features for accessing databases and flat files. Future versions of OWB will offer dedicated Web features.
Integrators are components dedicated to extracting data from a particular type of source.
Tighter integration with SAP will follow in later releases. OWB has an open interface that allows developers to extend its extraction capabilities while leveraging the benefits of the OWB framework. The final component is OWB Runtime, a set of tables, sequences, packages, and triggers installed in the target schema. OWB includes a runtime audit viewer for browsing the runtime tables and reports. OWB in Action Data-warehouse architects begin by finding out what questions business strategists want to answer.