Oracle 9i Warehouse Builder (OWB)
Computer
Training
Provided by Microsys Technologies and Solutions Pvt. Ltd.,
Introduction to Data warehousing
Data modeling
Data warehousing Architecture
Data warehousing consideration
Installation of Oracle Warehouse Builder 9i
OWB functional summary
Managing metadata
Introduction to Oracle discoverer
|
|
||||||||||||
Oracle 9i Warehouse Builder (OWB)
Day 1
Introduction to Data warehousing
What is Data warehousing?
Describe what a Data warehouse is?
Define a Data warehouse, Data mart?
What is the final delivery of Data warehousing?
Why are companies building Data Warehouses?
Goals of Data warehousing Strategy
Data modeling
Different Phases of Data modeling
Dimensional modeling
What are Dimensions and Facts?
Dimensional modeling techniques
Strengths of Dimensional Modeling
Star Schema
Dimensional Tables
SCD (slowly changing dimension)
Advanced dimensions
Fact Table
Advanced fact table designs
Snow Flake Star schema
Star Flake Star Schema
Multi-Dimensional model
Data warehousing Architecture
Data warehousing architecture A solution
Elements of Data warehouse
Data Sources
Integration layer
Staging area
Business Intelligence Architecture
Data Warehousing Life Cycle
ETL (Extraction Transformation Load)
What is Business Intelligence?
Know about Business Intelligence applications
Business Intelligence applications activities
Why Business Intelligence?
What is the main difference between Data warehousing and Business Intelligence?
Data warehousing consideration
A Suggested Design Approach
A suggested project approach
Alternative Approaches
The Enterprise Wide Data Warehouse - A Centralized Bottom Up Approach
Focused Data Marts - A Distributed Top Down Approach
Considerations for a Successful Warehousing Project
Data Warehousing - case study discussion
Introduction to Oracle Business Intelligence toolset
Introduction to Oracle warehouse builder 9i
Day 2
Installation of Oracle Warehouse Builder 9i
OWB functional summary
Components of OWB
Oracle warehouse repository
Creation of OWB Repository with OWB repository assistant
Common objects and their definition
Defining Source Metadata
Defining Staging Area Metadata
Defining source and targets
Designing ETL objects
Designing mappings
Using mapping operators
Transforming data with OWB
Using transformations
Transformation operators
Designing process flows
Deploying and Populating Staging Area Objects
Defining and Populating the Enterprise Model WareHouse
Defining and Populating Data Marts
Deploying and executing
Hands on practice session
Case study discussion
Day 3
Managing metadata
OWB Browser Meta-Data Reporting
Managing warehouse builder browser
Incremental Data Loading
Maintaining the Warehouse and Data Mart Objects
Testing Data warehouse
Migration and Sharing Metadata
OWB Bridges
Warehouse Operations : Scheduling and Sequencing OWB jobs with OEM and Workflow
Using OWB runtime assistant
Using OWB runtime audit viewer
Hand on practice session
Case study discussion and execution
Day 4
Introduction to Oracle discoverer
Execution of case study
Feedback and Review
About The Training Provider: Microsys Technologies and Solutions Pvt. Ltd.,
Microsys Technologies and Solutions Pvt. Ltd., - Microsys Technologies & Solutions Pvt. Ltd is a proactive organization headquartered in Pune with its branches across Mumbai & Bangalore. In the last few years of our existence we have successfully offered value propositions to our clientele across the country and overseas.
Customized Software Development
Corporate Training & IT Education
leadership and management skill programs
...
