OWB - Materialized View

Card Puncher Data Processing

About

The Oracle materialized view (MV) in OWB

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

Operator Materialized View Configuration





Discover More
Owb Table Operator Properties
OWB - Error Table Properties

This page describe the Error Table section of properties and you can find it only for the mapping operators where a load can be perform : Table, View , Materialized View, External Table, ...
Card Puncher Data Processing
OWB - Operators

The operators are used in a mapping to create a process and have several types : Source/Target Operators: These operators represent Oracle Database objects in the mapping. It also contains Flat File...
Card Puncher Data Processing
OWB - Target Operator

In a mapping, you can load data in the following operator: Table, View, Materialized View, External Table Dimension Cube flat file
Card Puncher Data Processing
OWB - Target Operator Name Properties

Under the operator name properties of a target mapping operator where you can load data such as: table, View, Materialized View, External Table you can set: Primary Source, Target Load...



Share this page:
Follow us:
Task Runner