OWB - Materialized View

> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder

1 - About

The Oracle materialized view (MV) in OWB

Advertising

3 - How to create it

To create an Oracle materialized view (MV) using OWB :

  1. Launch OWB and open your project
  2. Expand the Database node
  3. Expand the target module
  4. Right click on Materialized Views and select Create
  5. A wizard pops up containing 6 steps
    1. Give it a name
    2. Define the name, data type, and whether mandatory for each column
    3. Type or paste the MV SQL - just the select portion
    4. Define constraints - optional
    5. Define attribute sets - optional
    6. Finish
  6. After the MV has been created you can get back to the above wizard using right click on the MV and from the pop-up selecting Properties
  7. To set Build and Refresh characteristics, right click on the MV and from the pop-up select Configure

Advertising
dit/owb/materialized_view.txt · Last modified: 2017/09/06 19:53 by gerardnico