Introduction to Oracle Data Mart Builder - PowerPoint PPT Presentation

Loading...

PPT – Introduction to Oracle Data Mart Builder PowerPoint presentation | free to download - id: 218646-ZDc1Z



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Introduction to Oracle Data Mart Builder

Description:

Discoverer: Data Analysis. Data Mart Lifecycle. Data Modeling (Designer) ... (Discoverer) Designer: Data Modeling. E-R diagram (OLTP) Empty Tables (Data Mart) ... – PowerPoint PPT presentation

Number of Views:121
Avg rating:3.0/5.0
Slides: 11
Provided by: misp
Learn more at: http://gkmc.utah.edu
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Introduction to Oracle Data Mart Builder


1
  • Introduction to Oracle Data Mart Builder

2
Product Overview
  • Major components of Oracle Data Mart Suite
  • DesignerData Modeling
  • Builder Data Populating
  • Discoverer Data Analysis

3
Data Mart Lifecycle
Data Populating (Builder)
Data Modeling (Designer)
Data Analysis (Discoverer)
4
Designer Data Modeling

Star Schema (Data Mart)
E-R diagram (OLTP)
Empty Tables (Data Mart)
5
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

6
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.

7
Populating steps
  • Populate dimension tables
  • Populate time dimension tables
  • Populate stage table
  • Populate fact table

8
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
9
BaseView and MetaView
Data Flow Plan
Target BaseView
Source MetaView
Source BaseView
Target Data
Source Data
10
Documentation
  • Start -gt Programs -gt Oracle for Windows NT
    -gtOracle Data Mart Documentation

Data Mart Suite Cookbook
About PowerShow.com