Oracle Warehouse Builder II – ORA406
Oracle Warehouse Builder (OWB) instructs students in the use of the OWB toolset, to extract, transform and load data. This course is part II of the OWB training and covers more on the features of OWB and multidimensional model including cubes, online analytic processing (OLAP) and using spreadsheet Add-in to query OLAP data.
Oracle Warehouse Builder II – ORA406 Request a Class Date
Oracle Warehouse Builder (OWB) instructs students in the use of the OWB toolset, to extract, transform and load data. This course is part II of the OWB training and covers more on the features of OWB and multidimensional model including cubes, online analytic processing (OLAP) and using spreadsheet Add-in to query OLAP data.
Course ID: ORA406
Duration: 2 days
Audience: Developers responsible for extract, transform and load processes using OWB
Topics Covered in Oracle Warehouse Builder II Training Course:
Understanding Oracle OLAP Concepts and Technology
- Benefits of using OLAP for end users and for information technology (IT) in general
- Key advantages of Oracle OLAP
- Main features of a dimensional model
- Role of an analytic workspace in the Oracle database
- OWB OLAP Modeling and Deployment
Use additional dimension-modeling capabilities
- Use value-based, ragged-level, skip-level hierarchies
- Design the multi-dimensional modeling
- Using Spreadsheet Add-In to Query OLAP Data
Use OracleBI Spreadsheet Add-In in Microsoft Excel
- Connect to your Oracle OLAP data source
- Create OLAP queries
- Use Excel features on OLAP data
- Managing OWB Life-Cycle Changes
Use OWB Change Manager to take “snapshot” versions of metadata
- Use OWB Change Manager to, compare them, and restore them
- Use Metadata Dependency Manager to perform impact and lineage analysis
- Using the Mapping Debugger
Initialize a mapping debugging session
- Prepare the testing environment and test data
- Set breakpoints and watch points
- Run a test mapping
- Evaluate the flow of data to detect mapping errors
- Managing the Warehouse Builder Environment
Use OWB security management user interface
- Manage deployment and loading in a variety of configurations
- Creating Experts
Explain the benefits of Warehouse Builder Experts for novice users
- Use the Expert Editor to define an Expert