This course provides step-by-step procedures for installing, designing, customizing, and configuring Oracle Business Intelligence (BI) Applications and Oracle Business Intelligence Warehouse (OBAW). The course begins with an exploration of Oracle BI Applications components and architecture. You view demonstrations of the installation steps and then perform post-installation configuration of Oracle BI Applications, OBAW, and supporting technology. After the products are configured, you explore the prebuilt extract, transform, and load (ETL) metadata that ships with the products to gain an understanding of the ETL process and the relationships between the architecture components. You then explore Informatica ETL tools by building custom ETL mappings and workflows. After the initial exploration, you use Informatica and the Data Warehouse Administration Console (DAC) to configure ETL metadata and run a custom execution plan to load a subset of Siebel CRM data into the OBAW. Next, you learn to customize the OBAW by adding columns to an existing dimension table and adding a new dimension table. The course also covers: how Oracle BI Applications security is integrated with other Oracle products; how incremental updates and change capture processes are managed in ETL for Siebel data; how deletes are captured and applied to the data warehouse; and how to manage OBAW performance. Learn to:Explore prebuilt DAC and Informatica metadata, change capture processing, and delete management that support ETL for Siebel source dataUse the Data Warehouse Administration Console (DAC) to configure, manage, and load the Oracle Business Analytics WarehouseCustomize Informatica and DAC metadataCustomize the Oracle Business Analytics WarehouseManage Oracle Business Analytics Applications security and performanceInstall and configure BI Applications and the the Oracle Business Analytics WarehouseA Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.
Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.