After the installation and initial exploration, you use Informatica and the Data Warehouse Administration Console (DAC) to configure ETL metadata and run an execution plan to load Oracle E-Business Suite (EBS) data into the OBAW. After the data is loaded, you learn how to customize the OBAW by adding columns to an existing dimension table, and adding a new dimension. The course also covers how to integrate Oracle BI Applications security with other Oracle products, and how to manage OBAW performance.
- Install and configure Oracle Business Intelligence Applications and Oracle Business Analytics Warehouse
- Explore prebuilt ETL metadata, including Informatica workflows and mappings, and DAC metadata
- Use the Data Warehouse Administration Console (DAC) to configure, manage, and load the Oracle Business Analytics Warehouse
- Customize Informatica and DAC metadata
- Customize the Oracle Business Analytics Warehouse
- Manage Oracle Business Analytics Applications security and performance
- Business Intelligence Developer
- Data Warehouse Administrator
- Data Warehouse Analyst
- Technical Consultant
- Data Modelers
- Data Warehouse Developer
- Application Developers
- Working knowledge of Informatica PowerMart or PowerCenter
- Basic knowledge of SQL
- Experience in business intelligence
- Dimensional modeling, database design
- Oracle BI 10g: Analytics Overview
- Oracle BI Suite EE 10g R3: Create Reports and Dashboards
- Oracle BI Suite EE 10g R3: Build Repositories
- Explore Oracle Business Intelligence Applications and the Oracle Business Analytics Warehouse (OBAW) foundational concepts and architecture
- Install and configure Oracle BI Applications
- Explore the prebuilt extract, transform, and load (ETL) metadata for Oracle BI Applications
- Use the Data Warehouse Administration Console (DAC) to run ETL routines to populate the OBAW
- Customize DAC metadata
- Customize and extend the OBAW
- Manage the security and performance of Oracle BI Applications
Oracle Business Intelligence Applications Overview
- Exploring Oracle Business Intelligence (BI) Applications
- Exploring the key components of Oracle BI Applications
- Exploring Oracle BI Applications integration with transactional applications
Oracle Business Intelligence Applications Architecture Overview
- Exploring the Oracle BI Applications logical architecture
- Exploring the process flow of building the data warehouse
- Employing the recommended deployment options to maximize data warehouse performance
- Exploring the core components supporting the Oracle Business Analytics Warehouse (OBAW) and the functions performed by each core component
Oracle Business Analytics Warehouse Content
- Exploring the content of the Oracle Business Analytics Warehouse (OBAW)
- Exploring OBAW tables
Installing and Configuring Oracle BI Applications and Related Components
Understanding the ETL Process
- Exploring the extract, transform, and load (ETL) process used to load the Oracle Business Analytics Warehouse (OBAW)
- Identifying the differences between a full load and an incremental load of the OBAW
- Identifying the applications and mechanisms used to support the ETL process
Working with Informatica Designer
- Identifying the Informatica repository objects used to configure the Oracle Business Analytics Warehouse (OBAW)
- Navigating the set of tools in Informatica Designer used to configure Informatica repository objects
Working with Informatica Workflow Manager
- Navigating Informatica Workflow Manager
- Running workflows and sessions using Informatica Workflow Manager
- Monitoring workflows using Informatica Workflow Monitor
Exploring SDE and SIL Mappings
- Describing the differences between Source Dependent Extract (SDE) and Source Independent Load (SIL) mappings
- Identifying typical objects and their mechanics in SDE and SIL mappings
Working with the Data Warehouse Administration Console (DAC)
- Using the tools and views of the Data Warehouse Administration Console (DAC)
- Describing DAC objects, how they relate to each other, and their roles in the Oracle Business Analytics Warehouse (OBAW) extract, transform, and load (ETL) process
Configuring Analytical Applications
- Performing preload configuration steps that apply to Oracle Business Intelligence Applications deployed with any source system
- Configuring general ledger account hierarchies using general ledger accounting flexfield value set definitions
- Mapping Oracle general ledger natural accounts to group account numbers
- Creating a new metric in the repository after adding a new group account number
Customizing DAC Metadata and Running and Execution Plan
- Creating custom metadata objects in the DAC
- Running a DAC execution plan and monitoring the results
Customizing the Oracle Business Analytics Warehouse (OBAW)
- Identifying and describing customization types and scenarios associated with OBAW
- Applying OBAW customization best practices
Adding Columns to an Existing Dimension Table
- Completing the steps in a Type I customization of the OBAW
- Adding a column to an existing dimension table in the OBAW and populating it with data
Adding a New Dimension in OBAW
- Performing the customization steps for adding a new dimension to the Oracle Business Analytics Warehouse
Integrating Security for Oracle BI Applications
- Exploring the types of security in Oracle Business Intelligence Applications
- Synchronizing Oracle BI Application user groups with EBS responsibilities
- Identifying how BI Application authorization integrates with EBS responsibilities
- Describing a typical data security integration
Managing OBAW Performance
- Exploring strategies for increasing extract, transform, and load (ETL) and query performance
- Identifying common performance bottlenecks
- Configuring servers to optimize ETL and query performance