1. 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
- 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 OBAW and the functions performed by each Content
- Exploring the content of the Oracle Business Analytics Warehouse (OBAW)
- Exploring OBAW tables
- Identifying the installation prerequisites
- Configuring DAC
- Configuring Informatica Workflow Manager
- Exploring the extract, transform, and load (ETL) process used to load the 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
- 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
- Navigating Informatica Workflow Manager
- Running workflows and sessions using Informatica Workflow Manager
- Monitoring workflows using Informatica Workflow Monitor
- 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
- 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 OBAW
- Performing preload configuration steps that apply to BI APPS deployed with any source system
- Configuring GL account hierarchies using GL 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
- Creating custom metadata objects in the DAC
- Running a DAC execution plan and monitoring the results
- Identifying and describing customization types and scenarios associated with OBAW
- Applying OBAW customization best practices
- 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
- Performing the customization steps for adding a new dimension to the Oracle Business Analytics Warehouse
- Exploring the types of security in Oracle Business Intelligence Applications
- Describing how Oracle BI integrates with the Oracle Fusion Middleware security platform
- Identifying how BI Application object and data security integrate with EBS responsibilities
- Exploring strategies for increasing extract, transform, and load (ETL) and query performance
- Identifying common performance bottlenecks
- Configuring servers to optimize ETL and query performance
