Oracle 9i Warehouse Builder (OWB)
Computer
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
|
|
||||||||||
Training
Provided by Microsys Technologies and Solutions Pvt. Ltd.,
- asked: I am interested in data warehouse training using oracle warehouse builder in India. I am residing in bhopal and my company is interested in finding out a suitable training partner who can provide training.
- U asked: please provide their contact details
- K asked: Please mail the necessary details regarding corporate training at our Company premises for OWB. We are based out of Fridabad/Delhi-NCR. Regards, Karanbir Asst Mgr (HR) (login required)
- K asked: Hi - please let me know what the price of this course is? thanks .
- A asked: How much does the day course cost?
- asked: Hi. Is this training course available in or around Mumbai region ? Kindly let me know. Thanks. Mohamed Nadim.
- K asked: i want to learn owb . what abt the fee? and send me the details?
- asked: i want to learn owb . what abt the fee? and send me the details?
- P asked: hi would like to know the course contents, training calendar and the cost thanks Purushothaman
- S asked: where can i get information about training instiutes in pune or banglore
- J asked: Hi, We are looking for the various courses offered for Oracle Warehouse Builder across the nation. Please provide me details about this training:- .Please confirm the date schedule for this training. .Course Fee .Information about the trainer A prompt response will be highly appreciated. Regards Jyoti Gupta
- L asked: Requesting to inform any scheduled course on above subject line on next January' onward.
- M asked: Do you have this course conducted in mumbai?
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
...
