Transcript Oracle Data Mart Suite Tutorial

Introduction to Oracle Data
Mart Builder
Product Overview
Major components of Oracle Data Mart
Suite

Designer:Data Modeling
Builder: Data Populating
Discoverer: Data Analysis
Data Mart Lifecycle
Data Modeling
(Designer)
Data Populating
(Builder)
Data Analysis
(Discoverer)
Designer: Data Modeling
E-R diagram (OLTP)
Star Schema (Data
Mart)
Empty Tables (Data
Mart)
Builder: Data Populating
Manage the flow of data from sources to
the target data mart tables.
Extraction: define and select tables and
columns you want from the source (SQL
Query)
Transformation: calculation, aggregation,
rename etc.
Transportation: load data into data mart
Builder: Data Populating
Types of sources supported by Builder
Flat file:
fixed length: flat file with fixed length for each
field
character separated: flat file with fields separated
by characters
Relational database: Oracle, Sybase,
Informix, SQL Server etc.
Populating steps
Populate
Populate
Populate
Populate
dimension tables
time dimension tables
stage table
fact table
BaseView and MetaView
 A BaseView is a graphical representation of all or a
portion of a physical database, including the tables,
columns, and joins.
 A MetaView is the view you use to start building your
data flow plans.
Database
BaseView
MetaView
BaseView and MetaView
Data Flow Plan
Source
MetaView
Target
BaseView
Source
BaseView
Target Data
Source Data
Documentation
 Start -> Programs ->
Oracle for Windows NT ->
Oracle Data Mart Documentation
Data Mart Suite Cookbook