Oracle Data Warehouse Implementation

• Import and export metadata in Oracle WB
• Relationships between Oracle WB and a data warehouse development methodology
• Create metadata definitions for the Oracle WB repository
• Generate and update the data warehouse
• Generate extract and load programs
• Manage workflow dependencies with Oracle WB and schedule the execution of these programs
• the Discoverer
• describe the Oracle WB architecture

Unit 1 - The Oracle Warehouse Builder - Concepts

• Warehouse Builder concepts and architecture
• Oracle Warehouse Builder workflow approach
• the architecture of Oracle WB
• Components and high-level features of Oracle WB
• the design components
• the runtime components
• the security infrastructure

2. Unit - Setting up the Oracle Warehouse Builder

• installing and starting Oracle WB
• Recommended Oracle WB system requirements
• the three-tier and two-tier configuration
• security model
• Logon procedure
• Object locks
• the project console window
• Set preferences

3. Unit - Planning - Staging Area, Enterprise Warehouse and Dependent Data Marts

• Merging companies - comparison
• Information requirements
• Solution: Staging Area, Enterprise Warehouse and Dependent Data Marts
• OLTP source
• Enterprise Warehouse and Dependent Data Mart
• Develop a Logical Data Model for the complete target Data Mart

4. Unit - Defining source data for the Oracle Data Warehouse

• Define source metadata
• the data sources
• Source data from operating system files
• source data from relational tables - create database link
• create the source module
• the Flat File Sample Wizzard
• the Import Wizzard
• filtering objects to import

5. Unit - Define the staging area for the Oracle Data Warehouse

• Purpose of a staging area
• define the metadata of the staging area
• assign tables to the staging area module of the warehouse
• Create simple mappings, bindings and reconciliations
• create the mapping code
• add the Data Generator for synthetic keys and transformations
• filter, expression builder and key lookup operator
• Union, intersect and minus operators
• cut/copy/paste/delete objects

6. Unit - Setting up the Data Warehouse

• provide staging area objects
• customize storage parameters, indexes, tablespaces and partitions of tables
• the Graphical Mapping Editor of Oracle WB
• the Physical Implementation
• Use the validation tool before generating the warehouse
• Generate, deploy and display scripts

7. Unit - Performing Mappings and Transformations for the Oracle Data Warehouse

• define and populate an enterprise model
• Create synthetic keys
• Set attribute and operator properties
• Add custom properties to objects
• the Mapping Debugger
• Use predefined transformations and add mapping transformations
• Split, Joiner, Mapping External Tables, Table Function operators and other operators
• Reverse engineering of PL/SQL
• Globally shared functions
• the Physical Implementation

8. Unit - Update data and adjust dimensions

• load the data incrementally
• update warehouse data
• initial load and incremental load
• update facts and dimensions
• keep history when updating fact data
• update fact table via direct link to production system, schedule execution of updates
• Edit fact table via an operating system file
• Update dimension tables
• manage changing dimensions
• Backup and migration

9. Unit - Workflow and Job Processing in an Oracle DataWarehouse

• Define workflow sequence of Oracle WB jobs
• Automate and schedule load operations with OEM
• Register interdependent tasks in OEM
• Configure Oracle WB mappings for OEM job registration
• Manage Oracle WB job sequencing and dependencies with Oracle WB's Process Flow Editor
• Execute, route and monitor jobs

10. Unit - The Oracle DataWarehouse Repository

• Manage Warehouse and Data Mart objects
• Update Oracle WB repository with re-import
• update the warehouse to update the target schema
• the user interface for change management of metadata
• create metadata reports with the OWB Design Browser
• configure Oracle WB Design Browser
• Easy navigation in the OWB repository
• Reports in text and tabular form
• Create Lineage and Impact Analysis charts

Unit 11 - Oracle Datawarehouse and OLAP

• Oracle WB Bridges and OLAP Integration
• OLAP integration in Oracle WB
• Oracle WB Bridges for import and export of metadata
• Use the Transfer Wizzard
• Create extended attribute groups for exporting metadata to Discoverer

Windows or Linux knowledge SQL and PL/SQL

We conduct this seminar online for you. You can book the training as a public seminar or as a company seminar. The practical exercises are carried out in our Remotelab and make up 40-50 percent of the seminar.

• Implementation guarantee - Implementation guarantee for two or more participants
• Mobile classrooms - the ideal complement for company seminars
• Free support - for questions after the seminar
• Delivery on account - no prepayment required
• Interview with the trainer / quality assurance - get to know and assess the trainer in advance
• Clarify seminar requirements - review your knowledge with the trainer
• Assistance with travel costs - we cover part of the costs of hotel accommodation
• Meals - all day cold / hot drinks and a full lunch in the restaurant
• Location of training centres - always centrally located and easily accessible
• Discount - we have attractive prices, take advantage of our additional discounts
• Remotelabs - rent our Remotelabs for your own seminars or as a complement to your company seminars