1 / 10

Introduction to Oracle Data Mart Builder

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 Populating (Builder). Data Modeling (Designer). Data Analysis (Discoverer).

jake
Download Presentation

Introduction to Oracle Data Mart Builder

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introduction to Oracle Data Mart Builder

  2. Product Overview • Major components of Oracle Data Mart Suite • Designer:Data 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 Source MetaView Target BaseView Source BaseView Target Data Source Data

  10. Documentation • Start -> Programs -> Oracle for Windows NT ->Oracle Data Mart Documentation Data Mart Suite Cookbook

More Related