Work Area Objects Converted to Oracle LSH Schema and OWB Objects

Oracle Warehouse Builder converts defined objects in a Work Area to Oracle LSH schema objects as follows:

Table Instance

A Table instance becomes a database table, with any user-defined constraints and any system-defined or user-defined indexes as well as a data manipulation view, an associated Instead-Of trigger, and supporting PL/SQL package.

If a Table instance is defined as a pass-through view, it becomes a view in the database.

Executables

For each executable object—Program, Load Set, Report Set, Workflow, or Data Mart—the system creates its Table Descriptors as views onto the Table instances to which they are mapped and generates a PL/SQL package.

Source Table Descriptors each become a view that does the following:

• resolves the Table Descriptor to the real table

• maps Table Descriptor Columns to real table columns

• implements Oracle LSH's dynamic security mechanism

• implements currency snapshotting

• implements incremental data access

• implements blinding

Target Table Descriptors each become a view that does the following:

• resolves the Table Descriptors to the DML View

• maps Table Descriptor Columns to underlying table columns

• implements Oracle LSH's dynamic security mechanism

PL/SQL Programs, including those contained in Report Sets and Workflows, become:

• compiled PL/SQL code in an auxiliary schema or schemas

• synonyms to map names used in the PL/SQL Program to the proper source or target view in the primary schema

• synonyms to map names of external package references to packages in another auxiliary schema

For SAS and Oracle Reports Programs, OWB creates an OWB Task to call the DP Server and to grant access to the appropriate database tables.