Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

TechPubs Draft Modified: January 14, 2007 5:38 pm D R A F T Oracle® Business In

TechPubs Draft Modified: January 14, 2007 5:38 pm D R A F T Oracle® Business Intelligence Data Warehouse Administration Console Guide Version 7.9 January 2007 TechPubs Draft Modified: January 14, 2007 5:38 pm Part Number: B31978-01 Copyright © 2006, Oracle. All rights reserved. The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited. The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. This document is not warranted to be error- free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose. If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is applicable: U.S. GOVERNMENT RIGHTS. Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software--Restricted Rights (June 1987). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065. The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any damages caused by such use of the Programs. Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party. TechPubs Draft Modified: January 14, 2007 5:31 pm Oracle Business Intelligence Data Warehouse Administration Console Guide Version 7.9 3 Contents Oracle® Business Intelligence Data Warehouse Administration Console Guide 1 Chapter 1: What’s New in This Release Chapter 2: Overview of Oracle Business Analytics Warehouse Oracle Business Analytics Warehouse Overview 9 Oracle Business Analytics Warehouse Architecture 10 Oracle Business Analytics Warehouse Architecture Components 11 About the Data Warehouse Administration Console 12 About Source System Containers 15 About DAC Repository Objects 16 About the DAC Process Life Cycle 17 Chapter 3: Overview of the DAC Interface Navigating the DAC Interface 20 The DAC’s Menu Bar 21 The DAC’s Main Toolbar 24 The DAC’s Top Pane Toolbar 25 The DAC’s Right-Click Menus 26 The DAC’s Server Monitor Icons 30 The DAC’s Navigation Tree 31 The DAC’s Editable Lists 31 Using the DAC Query Functionality 32 DAC Query Commands and Operators 32 DAC Query Examples 33 Common DAC Query Procedures 33 About Object Ownership in the DAC 34 Chapter 4: Designing, Executing and Monitoring ETL Processes Considerations in Designing a Subject Area 37 Oracle Business Intelligence Data Warehouse Administration Console Guide Version 7.9 TechPubs Draft Modified: January 14, 2007 5:31 pm Contents ■ 4 Creating a Source System Container 39 Creating a Subject Area Using Existing Fact Tables 40 About Customizing Data Warehouse Tables and Columns 41 Adding a Table to the Data Warehouse 46 Adding a Column to an Existing Table 48 Working with Configuration Tags 49 Creating a Task Group 53 Setting Source System Parameters 54 Setting Task Level Parameters 55 Setting a Task Phase Dependency 55 Executing an Execution Plan with the DAC 56 Scheduling an Execution Plan 57 Monitoring Execution Plan Processes 57 Chapter 5: Common Tasks Performed in the DAC Distributing DAC Metadata 59 Running the DAC Server Automatically 60 Command Line Access to the DAC Server 61 Setting Up Command Line Access to the DAC Server 63 Using the Command Line to Access the DAC Server 63 DAC Repository Command Line Options 65 Replacing an Informatica Workflow with a Custom SQL File 67 Determining the Informatica Server Maximum Sessions Parameter Setting 68 Determining the Number of Transactional and Data Warehouse Database Connections 69 Running Two DAC Servers on the Same Machine 70 Customizing Index and Analyze Table Syntaxes 71 Implementing Micro ETL Processes 71 Using SQL Files as an Execution Type in the DAC 74 About the Change Capture Process 76 Initial Data Capture 76 Change Capture Process 76 Using the Change Capture Filter 81 TechPubs Draft Modified: January 14, 2007 5:31 pm Contents ■ Oracle Business Intelligence Data Warehouse Administration Console Guide Version 7.9 5 Tracking Deleted Records 81 Chapter 6: DAC Functional Reference Common Elements of DAC Interface Tabs 85 About the DAC Design View 85 About the DAC Subject Areas Tab 86 About the DAC Tables Tab 87 About the DAC Indices Tab 90 About Advanced Custom Index Management 92 About the DAC Task Groups Tab 92 About the DAC Tasks Tab 94 About the DAC Configuration Tags Tab 99 About the DAC Source System Parameters Tab 100 About the DAC Source System Folders Tab 100 About the DAC Setup View 100 About the DAC System Properties Tab 101 About the Informatica Servers Tab 105 About the Physical Data Sources Tab 106 About the Email Recipients Tab 108 About the DAC Execute View 108 About the DAC Execution Plans Tab 109 About the DAC Current Run Tab 113 About the DAC Run History Tab 116 About the DAC Scheduler Tab 116 Chapter 7: Troubleshooting Handling ETL Failures with the DAC 119 Index Oracle Business Intelligence Data Warehouse Administration Console Guide Version 7.9 TechPubs Draft Modified: January 14, 2007 5:31 pm Contents ■ 6 TechPubs Draft Modified: January 14, 2007 5:59 pm Oracle Business Intelligence Data Warehouse Administration Console Guide Version 7.9 7 Oracle Business Intelligence Data Warehouse Administration Console Guide 1 What’s New in This Release What’s New in Oracle Business Intelligence Data Warehouse Administration Console Guide, Version 7.9 The Oracle Business Intelligence Data Warehouse Administration Console Guide is a new guide in Release 7.9. Some of the information in this guide was previously published in the Siebel Business Analytics Applications Installation and Administration Guide. Oracle Business Intelligence Data Warehouse Administration Console Guide Version 7.9 TechPubs Draft Modified: January 14, 2007 5:59 pm What’s New in This Release ■ 8 TechPubs Draft Modified: January 14, 2007 10:46 am Oracle Business Intelligence Data Warehouse Administration Console Guide Version 7.9 9 2 Overview of Oracle Business Analytics Warehouse This chapter provides an overview of the Oracle Business Analytics Warehouse. It includes the following topics: ■ Oracle Business Analytics Warehouse Overview on page 9 ■ Oracle Business Analytics Warehouse Architecture on page 10 ■ About the Data Warehouse Administration Console on page 12 Oracle Business Analytics Warehouse Overview The Oracle Business Analytics Warehouse is a unified data repository for all customer-centric data. The purpose of the Oracle Business Analytics Warehouse is to support the analytical requirements of Oracle Business Intelligence Applications. The Oracle Business Analytics Warehouse includes the following: ■ A data integration engine that combines data from multiple source systems to build a data warehouse. ■ An open architecture to allow organizations to use third-party analytical tools in conjunction with the Oracle Business Analytics Warehouse using the Oracle Business Intelligence Server. ■ Prebuilt data extractors to incorporate data from external applications into the Oracle Business Analytics Warehouse. ■ A set of ETL (extract-transform-load) processes that takes data from multiple source systems and creates the Oracle Business Analytics Warehouse tables. ■ The Data Warehouse Administration Console (DAC), a centralized console for the set up, configuration, administration, loading, and monitoring of the Oracle Business Analytics Warehouse. Oracle Business Intelligence Data Warehouse Administration Console Guide Version 7.9 TechPubs Draft Modified: January 14, 2007 10:46 am Overview of Oracle Business Analytics Warehouse ■ uploads/s1/ dac-guide.pdf