Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpdw\target.db
<?xml version="1.0" encoding="UTF-8"?> <div element="book" href="toc.htm" number="" targetptr="TDPDW"> <ttl>Oracle® Database 2 Day + Data Warehousing Guide</ttl> <xreftext><cite>Oracle® Database 2 Day + Data Warehousing Guide</cite></xreftext> <div element="chapter" href="tdpdw_intro.htm" number="1" targetptr="TDPDW00100"> <ttl>Introduction to Data Warehousing</ttl> <xreftext>“Introduction to Data Warehousing”</xreftext> <div element="sect1" href="tdpdw_intro.htm" number="1.1" targetptr="TDPDW0011"> <ttl>About This Guide</ttl> <xreftext>“About This Guide”</xreftext> <div element="sect2" href="tdpdw_intro.htm" number="1.1.1" targetptr="TDPDW0016"> <ttl>Before Using This Guide</ttl> <xreftext>“Before Using This Guide”</xreftext> </div> <div element="sect2" href="tdpdw_intro.htm" number="1.1.2" targetptr="TDPDW0017"> <ttl>What This Guide Is Not</ttl> <xreftext>“What This Guide Is Not”</xreftext> </div> </div> <div element="sect1" href="tdpdw_intro.htm" number="1.2" targetptr="TDPDW0012"> <ttl>What is a Data Warehouse?</ttl> <xreftext>“What is a Data Warehouse?”</xreftext> <div element="sect2" href="tdpdw_intro.htm" number="1.2.1" targetptr="TDPDW0019"> <ttl>The Key Characteristics of a Data Warehouse</ttl> <xreftext>“The Key Characteristics of a Data Warehouse”</xreftext> </div> <div element="sect2" href="tdpdw_intro.htm" number="1.2.2" targetptr="TDPDW0013"> <ttl>Common Oracle Data Warehousing Tasks</ttl> <xreftext>“Common Oracle Data Warehousing Tasks”</xreftext> </div> </div> <div element="sect1" href="tdpdw_intro.htm" number="1.3" targetptr="TDPDW00170"> <ttl>Tasks Illustrated in this Guide</ttl> <xreftext>“Tasks Illustrated in this Guide”</xreftext> </div> <div element="sect1" href="tdpdw_intro.htm" number="1.4" targetptr="TDPDW0014"> <ttl>Tools for Administering the Data Warehouse</ttl> <xreftext>“Tools for Administering the Data Warehouse”</xreftext> </div> </div> <div element="chapter" href="tdpdw_system.htm" number="2" targetptr="TDPDW003"> <ttl>Setting Up Your Data Warehouse System</ttl> <xreftext>“Setting Up Your Data Warehouse System”</xreftext> <div element="sect1" href="tdpdw_system.htm" number="2.1" targetptr="TDPDW0027"> <ttl>General Steps for Setting up a Data Warehouse System</ttl> <xreftext>“General Steps for Setting up a Data Warehouse System”</xreftext> <obj element="bridgehead" href="tdpdw_system.htm" number="" targetptr=""> <ttl>To set up a data warehouse system, complete the following steps:</ttl> <xreftext>“To set up a data warehouse system, complete the following steps:”</xreftext> </obj> </div> <div element="sect1" href="tdpdw_system.htm" number="2.2" targetptr="TDPDW00172"> <ttl>Preparing the Environment</ttl> <xreftext>“Preparing the Environment”</xreftext> <div element="sect2" href="tdpdw_system.htm" number="2.2.1" targetptr="TDPDW0031"> <ttl>Balanced Hardware Configuration</ttl> <xreftext>“Balanced Hardware Configuration”</xreftext> <div element="sect3" href="tdpdw_system.htm" number="2.2.1.1" targetptr="TDPDW00311"> <ttl>How Many CPUs and What Clock Speed Do I Need?</ttl> <xreftext>“How Many CPUs and What Clock Speed Do I Need?”</xreftext> </div> <div element="sect3" href="tdpdw_system.htm" number="2.2.1.2" targetptr="TDPDW00312"> <ttl>How Much Memory Do I Need?</ttl> <xreftext>“How Much Memory Do I Need?”</xreftext> </div> <div element="sect3" href="tdpdw_system.htm" number="2.2.1.3" targetptr="TDPDW00313"> <ttl>How Many Disks Do I Need?</ttl> <xreftext>“How Many Disks Do I Need?”</xreftext> </div> <div element="sect3" href="tdpdw_system.htm" number="2.2.1.4" targetptr="TDPDW00314"> <ttl>How Do I Determine Sufficient I/O Bandwidth?</ttl> <xreftext>“How Do I Determine Sufficient I/O Bandwidth?”</xreftext> <obj element="table" href="tdpdw_system.htm" number="2-1" targetptr=""> <ttl>Throughput Performance Conversion</ttl> <xreftext>“Throughput Performance Conversion”</xreftext> </obj> <obj element="bridgehead" href="tdpdw_system.htm" number="" targetptr="TDPDW0034"> <ttl>About Automatic Storage Management (ASM)</ttl> <xreftext>“About Automatic Storage Management (ASM)”</xreftext> </obj> </div> </div> <div element="sect2" href="tdpdw_system.htm" number="2.2.2" targetptr="TDPDW0032"> <ttl>Verifying the Data Warehouse Hardware Configuration</ttl> <xreftext>“Verifying the Data Warehouse Hardware Configuration”</xreftext> <div element="sect3" href="tdpdw_system.htm" number="2.2.2.1" targetptr="TDPDW00321"> <ttl>About the dd Utility</ttl> <xreftext>“About the dd Utility”</xreftext> </div> <div element="sect3" href="tdpdw_system.htm" number="2.2.2.2" targetptr="TDPDW0036"> <ttl>Example: Using the dd Utility</ttl> <xreftext>“Example: Using the dd Utility”</xreftext> <obj element="bridgehead" href="tdpdw_system.htm" number="" targetptr=""> <ttl>To use the dd utility:</ttl> <xreftext>“To use the <code>dd</code> utility:”</xreftext> </obj> </div> <div element="sect3" href="tdpdw_system.htm" number="2.2.2.3" targetptr="TDPDW00322"> <ttl>About the Orion Utility</ttl> <xreftext>“About the Orion Utility”</xreftext> <obj element="bridgehead" href="tdpdw_system.htm" number="" targetptr=""> <ttl>To download Orion software, point your browser to the following:</ttl> <xreftext>“To download Orion software, point your browser to the following:”</xreftext> </obj> </div> <div element="sect3" href="tdpdw_system.htm" number="2.2.2.4" targetptr="TDPDW0037"> <ttl>Example: Using the Orion Utility</ttl> <xreftext>“Example: Using the Orion Utility”</xreftext> </div> </div> </div> <div element="sect1" href="tdpdw_system.htm" number="2.3" targetptr="TDPDW0033"> <ttl>Setting Up a Database for a Data Warehouse</ttl> <xreftext>“Setting Up a Database for a Data Warehouse”</xreftext> <div element="sect2" href="tdpdw_system.htm" number="2.3.1" targetptr="TDPDW00331"> <ttl>How Should I Set the Memory Management Parameters?</ttl> <xreftext>“How Should I Set the Memory Management Parameters?”</xreftext> </div> <div element="sect2" href="tdpdw_system.htm" number="2.3.2" targetptr="TDPDW00332"> <ttl>Example: Setting an Initialization Parameter</ttl> <xreftext>“Example: Setting an Initialization Parameter”</xreftext> </div> <div element="sect2" href="tdpdw_system.htm" number="2.3.3" targetptr="TDPDW00333"> <ttl>What Other Initialization Parameter Settings Are Important?</ttl> <xreftext>“What Other Initialization Parameter Settings Are Important?”</xreftext> </div> </div> <div element="sect1" href="tdpdw_system.htm" number="2.4" targetptr="TDPDW00173"> <ttl>Accessing Oracle Warehouse Builder</ttl> <xreftext>“Accessing Oracle Warehouse Builder”</xreftext> <obj element="bridgehead" href="tdpdw_system.htm" number="" targetptr=""> <ttl>To enable Warehouse Builder, complete the following steps:</ttl> <xreftext>“To enable Warehouse Builder, complete the following steps:”</xreftext> </obj> <div element="sect2" href="tdpdw_system.htm" number="2.4.1" targetptr="TDPDW00174"> <ttl>Installing the Oracle Warehouse Builder Demonstration</ttl> <xreftext>“Installing the Oracle Warehouse Builder Demonstration”</xreftext> <obj element="bridgehead" href="tdpdw_system.htm" number="" targetptr=""> <ttl>To perform the Warehouse Builder exercises presented in this guide, complete the following steps:</ttl> <xreftext>“To perform the Warehouse Builder exercises presented in this guide, complete the following steps:”</xreftext> </obj> </div> </div> </div> <div element="chapter" href="tdpdw_owb_sources.htm" number="3" targetptr="TDPDW10500"> <ttl>Identifying Data Sources and Importing Metadata</ttl> <xreftext>“Identifying Data Sources and Importing Metadata”</xreftext> <div element="sect1" href="tdpdw_owb_sources.htm" number="3.1" targetptr="TDPDW12002"> <ttl>Overview of Data Sources</ttl> <xreftext>“Overview of Data Sources”</xreftext> </div> <div element="sect1" href="tdpdw_owb_sources.htm" number="3.2" targetptr="TDPDW00175"> <ttl>General Steps for Importing Metadata from Sources</ttl> <xreftext>“General Steps for Importing Metadata from Sources”</xreftext> <obj element="bridgehead" href="tdpdw_owb_sources.htm" number="" targetptr=""> <ttl>To import metadata, complete the following steps:</ttl> <xreftext>“To import metadata, complete the following steps:”</xreftext> </obj> </div> <div element="sect1" href="tdpdw_owb_sources.htm" number="3.3" targetptr="TDPDW12003"> <ttl>About Workspaces, Projects, and other Devices in Warehouse Builder</ttl> <xreftext>“About Workspaces, Projects, and other Devices in Warehouse Builder”</xreftext> </div> <div element="sect1" href="tdpdw_owb_sources.htm" number="3.4" targetptr="TDPDW04365"> <ttl>Example: Importing Metadata from Flat Files</ttl> <xreftext>“Example: Importing Metadata from Flat Files”</xreftext> <obj element="bridgehead" href="tdpdw_owb_sources.htm" number="" targetptr=""> <ttl>To import metadata from flat files:</ttl> <xreftext>“To import metadata from flat files:”</xreftext> </obj> <div element="sect2" href="tdpdw_owb_sources.htm" number="3.4.1" targetptr="TDPDW12004"> <ttl>Specifying Locations for the Flat Files</ttl> <xreftext>“Specifying Locations for the Flat Files”</xreftext> </div> <div element="sect2" href="tdpdw_owb_sources.htm" number="3.4.2" targetptr="TDPDW12005"> <ttl>Creating Modules in the Project</ttl> <xreftext>“Creating Modules in the Project”</xreftext> </div> <div element="sect2" href="tdpdw_owb_sources.htm" number="3.4.3" targetptr="TDPDW12006"> <ttl>Launching the Import Metadata Wizard</ttl> <xreftext>“Launching the Import Metadata Wizard”</xreftext> </div> <div element="sect2" href="tdpdw_owb_sources.htm" number="3.4.4" targetptr="TDPDW12007"> <ttl>Using the Flat File Sample Wizard</ttl> <xreftext>“Using the Flat File Sample Wizard”</xreftext> </div> <div element="sect2" href="tdpdw_owb_sources.htm" number="3.4.5" targetptr="TDPDW12008"> <ttl>Importing the Flat File Data</ttl> <xreftext>“Importing the Flat File Data”</xreftext> </div> </div> </div> <div element="chapter" href="tdpdw_owb_def_objs.htm" number="4" targetptr="TDPDW10400"> <ttl>Defining Warehouses in Oracle Warehouse Builder</ttl> <xreftext>“Defining Warehouses in Oracle Warehouse Builder”</xreftext> <div element="sect1" href="tdpdw_owb_def_objs.htm" number="4.1" targetptr="TDPDW00177"> <ttl>General Steps for Defining a Relational Target Warehouse</ttl> <xreftext>“General Steps for Defining a Relational Target Warehouse”</xreftext> <obj element="bridgehead" href="tdpdw_owb_def_objs.htm" number="" targetptr=""> <ttl>To define a relational target warehouse, complete the following steps:</ttl> <xreftext>“To define a relational target warehouse, complete the following steps:”</xreftext> </obj> </div> <div element="sect1" href="tdpdw_owb_def_objs.htm" number="4.2" targetptr="TDPDW00178"> <ttl>Identifying the Warehouse Target Schema</ttl> <xreftext>“Identifying the Warehouse Target Schema”</xreftext> <obj element="bridgehead" href="tdpdw_owb_def_objs.htm" number="" targetptr=""> <ttl>To designate a schema as the data warehouse target schema:</ttl> <xreftext>“To designate a schema as the data warehouse target schema:”</xreftext> </obj> </div> <div element="sect1" href="tdpdw_owb_def_objs.htm" number="4.3" targetptr="TDPDW12009"> <ttl>About Flat File Sources in Warehouse Builder</ttl> <xreftext>“About Flat File Sources in Warehouse Builder”</xreftext> <div element="sect2" href="tdpdw_owb_def_objs.htm" number="4.3.1" targetptr="TDPDW00179"> <ttl>Exercise: Adding External Tables to the Target Module</ttl> <xreftext>“Exercise: Adding External Tables to the Target Module”</xreftext> <obj element="bridgehead" href="tdpdw_owb_def_objs.htm" number="" targetptr=""> <ttl>To add external tables to the target warehouse module:</ttl> <xreftext>“To add external tables to the target warehouse module:”</xreftext> </obj> </div> </div> <div element="sect1" href="tdpdw_owb_def_objs.htm" number="4.4" targetptr="TDPDW12010"> <ttl>About Dimensions</ttl> <xreftext>“About Dimensions”</xreftext> <div element="sect2" href="tdpdw_owb_def_objs.htm" number="4.4.1" targetptr="TDPDW12011"> <ttl>Exercise: Understanding Dimensions</ttl> <xreftext>“Exercise: Understanding Dimensions”</xreftext> <obj element="bridgehead" href="tdpdw_owb_def_objs.htm" number="" targetptr=""> <ttl>To become familiar with the dimensions:</ttl> <xreftext>“To become familiar with the dimensions:”</xreftext> </obj> <div element="sect3" href="tdpdw_owb_def_objs.htm" number="4.4.1.1" targetptr="TDPDW12012"> <ttl>About Levels</ttl> <xreftext>“About Levels”</xreftext> </div> <div element="sect3" href="tdpdw_owb_def_objs.htm" number="4.4.1.2" targetptr="TDPDW12013"> <ttl>Defining Level Attributes</ttl> <xreftext>“Defining Level Attributes”</xreftext> </div> <div element="sect3" href="tdpdw_owb_def_objs.htm" number="4.4.1.3" targetptr="TDPDW12014"> <ttl>Defining Hierarchies</ttl> <xreftext>“Defining Hierarchies”</xreftext> </div> <div element="sect3" href="tdpdw_owb_def_objs.htm" number="4.4.1.4" targetptr="TDPDW12015"> <ttl>Dimension Roles</ttl> <xreftext>“Dimension Roles”</xreftext> </div> <div element="sect3" href="tdpdw_owb_def_objs.htm" number="4.4.1.5" targetptr="TDPDW12016"> <ttl>Level Relationships</ttl> <xreftext>“Level Relationships”</xreftext> </div> <div element="sect3" href="tdpdw_owb_def_objs.htm" number="4.4.1.6" targetptr="TDPDW12017"> <ttl>Dimension Example</ttl> <xreftext>“Dimension Example”</xreftext> <obj element="table" href="tdpdw_owb_def_objs.htm" number="4-1" targetptr=""> <ttl>Products Dimension Level Details</ttl> <xreftext>“Products Dimension Level Details”</xreftext> </obj> </div> <div element="sect3" href="tdpdw_owb_def_objs.htm" number="4.4.1.7" targetptr="TDPDW12018"> <ttl>Control Rows</ttl> <xreftext>“Control Rows”</xreftext> <obj element="table" href="tdpdw_owb_def_objs.htm" number="4-2" targetptr=""> <ttl>Control Rows Created for the Products Dimension</ttl> <xreftext>“Control Rows Created for the Products Dimension”</xreftext> </obj> </div> </div> <div element="sect2" href="tdpdw_owb_def_objs.htm" number="4.4.2" targetptr="TDPDW12019"> <ttl>Implementing a Dimension</ttl> <xreftext>“Implementing a Dimension”</xreftext> <div element="sect3" href="tdpdw_owb_def_objs.htm" number="4.4.2.1" targetptr="TDPDW12020"> <ttl>Star Schema</ttl> <xreftext>“Star Schema”</xreftext> </div> <div element="sect3" href="tdpdw_owb_def_objs.htm" number="4.4.2.2" targetptr="TDPDW12021"> <ttl>Binding</ttl> <xreftext>“Binding”</xreftext> <obj element="bridgehead" href="tdpdw_owb_def_objs.htm" number="" targetptr="BABBICDE"> <ttl>Auto Binding</ttl> <xreftext>“Auto Binding”</xreftext> </obj> <obj element="bridgehead" href="tdpdw_owb_def_objs.htm" number="" targetptr=""> <ttl>To perform auto binding:</ttl> <xreftext>“To perform auto binding:”</xreftext> </obj> <obj element="bridgehead" href="tdpdw_owb_def_objs.htm" number="" targetptr="BABGHCDH"> <ttl>Manual Binding</ttl> <xreftext>“Manual Binding”</xreftext> </obj> <obj element="bridgehead" href="tdpdw_owb_def_objs.htm" number="" targetptr=""> <ttl>To perform manual binding for a dimension:</ttl> <xreftext>“To perform manual binding for a dimension:”</xreftext> </obj> </div> </div> </div> <div element="sect1" href="tdpdw_owb_def_objs.htm" number="4.5" targetptr="TDPDW12022"> <ttl>About Cubes</ttl> <xreftext>“About Cubes”</xreftext> <div element="sect2" href="tdpdw_owb_def_objs.htm" number="4.5.1" targetptr="TDPDW12023"> <ttl>Defining a Cube</ttl> <xreftext>“Defining a Cube”</xreftext> <div element="sect3" href="tdpdw_owb_def_objs.htm" number="4.5.1.1" targetptr="TDPDW12024"> <ttl>Cube Measures</ttl> <xreftext>“Cube Measures”</xreftext> </div> <div element="sect3" href="tdpdw_owb_def_objs.htm" number="4.5.1.2" targetptr="TDPDW12025"> <ttl>Cube Dimensionality</ttl> <xreftext>“Cube Dimensionality”</xreftext> <obj element="bridgehead" href="tdpdw_owb_def_objs.htm" number="" targetptr=""> <ttl>To define a dimension reference, specify the following:</ttl> <xreftext>“To define a dimension reference, specify the following:”</xreftext> </obj> </div> <div element="sect3" href="tdpdw_owb_def_objs.htm" number="4.5.1.3" targetptr="TDPDW12026"> <ttl>Cube Example</ttl> <xreftext>“Cube Example”</xreftext> <obj element="table" href="tdpdw_owb_def_objs.htm" number="4-3" targetptr=""> <ttl>Dimensionality of the Sales Cube</ttl> <xreftext>“Dimensionality of the Sales Cube”</xreftext> </obj> </div> </div> <div element="sect2" href="tdpdw_owb_def_objs.htm" number="4.5.2" targetptr="TDPDW12027"> <ttl>Implementing a Cube</ttl> <xreftext>“Implementing a Cube”</xreftext> <div element="sect3" href="tdpdw_owb_def_objs.htm" number="4.5.2.1" targetptr="TDPDW12028"> <ttl>Relational Implementation of a Cube</ttl> <xreftext>“Relational Implementation of a Cube”</xreftext> <obj element="bridgehead" href="tdpdw_owb_def_objs.htm" number="" targetptr=""> <ttl>To implement a cube:</ttl> <xreftext>“To implement a cube:”</xreftext> </obj> </div> <div element="sect3" href="tdpdw_owb_def_objs.htm" number="4.5.2.2" targetptr="TDPDW12029"> <ttl>Binding</ttl> <xreftext>“Binding”</xreftext> <obj element="bridgehead" href="tdpdw_owb_def_objs.htm" number="" targetptr=""> <ttl>Auto Binding</ttl> <xreftext>“Auto Binding”</xreftext> </obj> <obj element="bridgehead" href="tdpdw_owb_def_objs.htm" number="" targetptr=""> <ttl>Manual Binding</ttl> <xreftext>“Manual Binding”</xreftext> </obj> <obj element="bridgehead" href="tdpdw_owb_def_objs.htm" number="" targetptr=""> <ttl>To perform manual binding for a cube:</ttl> <xreftext>“To perform manual binding for a cube:”</xreftext> </obj> </div> </div> </div> </div> <div element="chapter" href="tdpdw_owb_etl_design.htm" number="5" targetptr="TDPDW00273"> <ttl>Defining ETL Logic</ttl> <xreftext>“Defining ETL Logic”</xreftext> <div element="sect1" href="tdpdw_owb_etl_design.htm" number="5.1" targetptr="TDPDW04260"> <ttl>About Mappings and Operators</ttl> <xreftext>“About Mappings and Operators”</xreftext> </div> <div element="sect1" href="tdpdw_owb_etl_design.htm" number="5.2" targetptr="TDPDW04261"> <ttl>Instructions for Defining Mappings</ttl> <xreftext>“Instructions for Defining Mappings”</xreftext> <obj element="bridgehead" href="tdpdw_owb_etl_design.htm" number="" targetptr=""> <ttl>To define a mapping, refer to the following sections:</ttl> <xreftext>“To define a mapping, refer to the following sections:”</xreftext> </obj> <obj element="bridgehead" href="tdpdw_owb_etl_design.htm" number="" targetptr=""> <ttl>Subsequent Steps</ttl> <xreftext>“Subsequent Steps”</xreftext> </obj> </div> <div element="sect1" href="tdpdw_owb_etl_design.htm" number="5.3" targetptr="TDPDW12030"> <ttl>Creating a Mapping</ttl> <xreftext>“Creating a Mapping”</xreftext> <obj element="bridgehead" href="tdpdw_owb_etl_design.htm" number="" targetptr=""> <ttl>To create a mapping:</ttl> <xreftext>“To create a mapping:”</xreftext> </obj> <obj element="bridgehead" href="tdpdw_owb_etl_design.htm" number="" targetptr=""> <ttl>To open a previously created mapping:</ttl> <xreftext>“To open a previously created mapping:”</xreftext> </obj> <div element="sect2" href="tdpdw_owb_etl_design.htm" number="5.3.1" targetptr="TDPDW12031"> <ttl>Types of Operators</ttl> <xreftext>“Types of Operators”</xreftext> </div> </div> <div element="sect1" href="tdpdw_owb_etl_design.htm" number="5.4" targetptr="TDPDW12032"> <ttl>Adding Operators</ttl> <xreftext>“Adding Operators”</xreftext> <obj element="bridgehead" href="tdpdw_owb_etl_design.htm" number="" targetptr=""> <ttl>To add an operator to a mapping:</ttl> <xreftext>“To add an operator to a mapping:”</xreftext> </obj> <div element="sect2" href="tdpdw_owb_etl_design.htm" number="5.4.1" targetptr="TDPDW12033"> <ttl>Adding Operators that Bind to Workspace Objects</ttl> <xreftext>“Adding Operators that Bind to Workspace Objects”</xreftext> <div element="sect3" href="tdpdw_owb_etl_design.htm" number="5.4.1.1" targetptr="TDPDW12034"> <ttl>Create Unbound Operator with No Attributes</ttl> <xreftext>“Create Unbound Operator with No Attributes”</xreftext> </div> <div element="sect3" href="tdpdw_owb_etl_design.htm" number="5.4.1.2" targetptr="TDPDW12035"> <ttl>Select from Existing Workspace Object and Bind</ttl> <xreftext>“Select from Existing Workspace Object and Bind”</xreftext> </div> </div> </div> <div element="sect1" href="tdpdw_owb_etl_design.htm" number="5.5" targetptr="TDPDW12036"> <ttl>Editing Operators</ttl> <xreftext>“Editing Operators”</xreftext> <obj element="bridgehead" href="tdpdw_owb_etl_design.htm" number="" targetptr=""> <ttl>To edit an operator, group, or attribute:</ttl> <xreftext>“To edit an operator, group, or attribute:”</xreftext> </obj> </div> <div element="sect1" href="tdpdw_owb_etl_design.htm" number="5.6" targetptr="TDPDW12037"> <ttl>Connecting Operators</ttl> <xreftext>“Connecting Operators”</xreftext> <div element="sect2" href="tdpdw_owb_etl_design.htm" number="5.6.1" targetptr="TDPDW12038"> <ttl>Connecting Attributes</ttl> <xreftext>“Connecting Attributes”</xreftext> <obj element="bridgehead" href="tdpdw_owb_etl_design.htm" number="" targetptr=""> <ttl>To connect attributes:</ttl> <xreftext>“To connect attributes:”</xreftext> </obj> </div> <div element="sect2" href="tdpdw_owb_etl_design.htm" number="5.6.2" targetptr="TDPDW12039"> <ttl>Connecting Groups</ttl> <xreftext>“Connecting Groups”</xreftext> <div element="sect3" href="tdpdw_owb_etl_design.htm" number="5.6.2.1" targetptr="TDPDW12040"> <ttl>Example: Using the Mapping Editor to Create Staging Area Tables</ttl> <xreftext>“Example: Using the Mapping Editor to Create Staging Area Tables”</xreftext> <obj element="bridgehead" href="tdpdw_owb_etl_design.htm" number="" targetptr=""> <ttl>To map a source table to a staging table:</ttl> <xreftext>“To map a source table to a staging table:”</xreftext> </obj> </div> </div> </div> <div element="sect1" href="tdpdw_owb_etl_design.htm" number="5.7" targetptr="TDPDW12041"> <ttl>Setting Mapping Properties</ttl> <xreftext>“Setting Mapping Properties”</xreftext> <div element="sect2" href="tdpdw_owb_etl_design.htm" number="5.7.1" targetptr="TDPDW12042"> <ttl>Target Load Order</ttl> <xreftext>“Target Load Order”</xreftext> <obj element="bridgehead" href="tdpdw_owb_etl_design.htm" number="" targetptr=""> <ttl>To specify the loading order for multiple targets:</ttl> <xreftext>“To specify the loading order for multiple targets:”</xreftext> </obj> <div element="sect3" href="tdpdw_owb_etl_design.htm" number="5.7.1.1" targetptr="TDPDW12043"> <ttl>Reset to Default</ttl> <xreftext>“Reset to Default”</xreftext> </div> </div> </div> <div element="sect1" href="tdpdw_owb_etl_design.htm" number="5.8" targetptr="TDPDW12044"> <ttl>Setting Operator, Group, and Attribute Properties</ttl> <xreftext>“Setting Operator, Group, and Attribute Properties”</xreftext> </div> <div element="sect1" href="tdpdw_owb_etl_design.htm" number="5.9" targetptr="TDPDW12045"> <ttl>Synchronizing Operators and Workspace Objects</ttl> <xreftext>“Synchronizing Operators and Workspace Objects”</xreftext> <div element="sect2" href="tdpdw_owb_etl_design.htm" number="5.9.1" targetptr="TDPDW12046"> <ttl>Synchronizing An Operator</ttl> <xreftext>“Synchronizing An Operator”</xreftext> <obj element="bridgehead" href="tdpdw_owb_etl_design.htm" number="" targetptr=""> <ttl>To synchronize an operator, complete the following steps:</ttl> <xreftext>“To synchronize an operator, complete the following steps:”</xreftext> </obj> </div> <div element="sect2" href="tdpdw_owb_etl_design.htm" number="5.9.2" targetptr="TDPDW12047"> <ttl>Synchronizing From a Workspace Object to an Operator</ttl> <xreftext>“Synchronizing From a Workspace Object to an Operator”</xreftext> <div element="sect3" href="tdpdw_owb_etl_design.htm" number="5.9.2.1" targetptr="TDPDW12048"> <ttl>Synchronizing Operators based on Workspace Objects</ttl> <xreftext>“Synchronizing Operators based on Workspace Objects”</xreftext> <obj element="table" href="tdpdw_owb_etl_design.htm" number="5-1" targetptr=""> <ttl>Operators Synchronized with Workspace Objects</ttl> <xreftext>“Operators Synchronized with Workspace Objects”</xreftext> </obj> </div> </div> <div element="sect2" href="tdpdw_owb_etl_design.htm" number="5.9.3" targetptr="TDPDW12049"> <ttl>Synchronizing from an Operator to a Workspace Object</ttl> <xreftext>“Synchronizing from an Operator to a Workspace Object”</xreftext> </div> </div> </div> <div element="chapter" href="tdpdw_owb_deploy.htm" number="6" targetptr="TDPDW11100"> <ttl>Deploying to Target Schemas and Executing ETL Logic</ttl> <xreftext>“Deploying to Target Schemas and Executing ETL Logic”</xreftext> <div element="sect1" href="tdpdw_owb_deploy.htm" number="6.1" targetptr="TDPDW12062"> <ttl>About Deployment</ttl> <xreftext>“About Deployment”</xreftext> <div element="sect2" href="tdpdw_owb_deploy.htm" number="6.1.1" targetptr="TDPDW12063"> <ttl>What is a Control Center?</ttl> <xreftext>“What is a Control Center?”</xreftext> <obj element="bridgehead" href="tdpdw_owb_deploy.htm" number="" targetptr=""> <ttl>To create a new Control Center:</ttl> <xreftext>“To create a new Control Center:”</xreftext> </obj> <obj element="bridgehead" href="tdpdw_owb_deploy.htm" number="" targetptr=""> <ttl>To make a Control Center active:</ttl> <xreftext>“To make a Control Center active:”</xreftext> </obj> </div> <div element="sect2" href="tdpdw_owb_deploy.htm" number="6.1.2" targetptr="TDPDW12064"> <ttl>Configuring the Physical Details of Deployment</ttl> <xreftext>“Configuring the Physical Details of Deployment”</xreftext> </div> <div element="sect2" href="tdpdw_owb_deploy.htm" number="6.1.3" targetptr="TDPDW12065"> <ttl>Deployment Actions</ttl> <xreftext>“Deployment Actions”</xreftext> </div> <div element="sect2" href="tdpdw_owb_deploy.htm" number="6.1.4" targetptr="TDPDW12066"> <ttl>The Deployment Process</ttl> <xreftext>“The Deployment Process”</xreftext> </div> </div> <div element="sect1" href="tdpdw_owb_deploy.htm" number="6.2" targetptr="TDPDW12069"> <ttl>Deploying Objects</ttl> <xreftext>“Deploying Objects”</xreftext> <obj element="bridgehead" href="tdpdw_owb_deploy.htm" number="" targetptr=""> <ttl>To deploy from the Project Explorer:</ttl> <xreftext>“To deploy from the Project Explorer:”</xreftext> </obj> <obj element="bridgehead" href="tdpdw_owb_deploy.htm" number="" targetptr=""> <ttl>To open the Control Center Manager:</ttl> <xreftext>“To open the Control Center Manager:”</xreftext> </obj> </div> <div element="sect1" href="tdpdw_owb_deploy.htm" number="6.3" targetptr="TDPDW12070"> <ttl>Starting ETL Jobs</ttl> <xreftext>“Starting ETL Jobs”</xreftext> <obj element="bridgehead" href="tdpdw_owb_deploy.htm" number="" targetptr=""> <ttl>To start ETL from the Project Explorer:</ttl> <xreftext>“To start ETL from the Project Explorer:”</xreftext> </obj> <div element="sect2" href="tdpdw_owb_deploy.htm" number="6.3.1" targetptr="TDPDW12071"> <ttl>Viewing the Data</ttl> <xreftext>“Viewing the Data”</xreftext> <obj element="bridgehead" href="tdpdw_owb_deploy.htm" number="" targetptr=""> <ttl>To view the data:</ttl> <xreftext>“To view the data:”</xreftext> </obj> </div> </div> </div> <div element="chapter" href="tdpdw_sql.htm" number="7" targetptr="TDPDW007"> <ttl>SQL for Reporting and Analysis</ttl> <xreftext>“SQL for Reporting and Analysis”</xreftext> <div element="sect1" href="tdpdw_sql.htm" number="7.1" targetptr="TDPDW0071"> <ttl>Use of SQL Analytic Capabilities to Answer Business Queries</ttl> <xreftext>“Use of SQL Analytic Capabilities to Answer Business Queries”</xreftext> <div element="sect2" href="tdpdw_sql.htm" number="7.1.1" targetptr="TDPDW00711"> <ttl>How to Add Totals to Reports Using the ROLLUP Function</ttl> <xreftext>“How to Add Totals to Reports Using the ROLLUP Function”</xreftext> <div element="sect3" href="tdpdw_sql.htm" number="7.1.1.1" targetptr="TDPDW00719"> <ttl>When to Use the ROLLUP Function</ttl> <xreftext>“When to Use the ROLLUP Function”</xreftext> </div> <div element="sect3" href="tdpdw_sql.htm" number="7.1.1.2" targetptr="TDPDW00720"> <ttl>Example: Using the ROLLUP Function</ttl> <xreftext>“Example: Using the ROLLUP Function”</xreftext> </div> </div> <div element="sect2" href="tdpdw_sql.htm" number="7.1.2" targetptr="TDPDW00712"> <ttl>How to Separate Totals at Different Levels Using the CUBE Function</ttl> <xreftext>“How to Separate Totals at Different Levels Using the CUBE Function”</xreftext> <div element="sect3" href="tdpdw_sql.htm" number="7.1.2.1" targetptr="TDPDW00738"> <ttl>When to Use the CUBE Function</ttl> <xreftext>“When to Use the CUBE Function”</xreftext> </div> <div element="sect3" href="tdpdw_sql.htm" number="7.1.2.2" targetptr="TDPDW00734"> <ttl>Example: Using the CUBE Function</ttl> <xreftext>“Example: Using the CUBE Function”</xreftext> <obj element="bridgehead" href="tdpdw_sql.htm" number="" targetptr=""> <ttl>To use the CUBE function:</ttl> <xreftext>“To use the <code>CUBE</code> function:”</xreftext> </obj> </div> </div> <div element="sect2" href="tdpdw_sql.htm" number="7.1.3" targetptr="TDPDW00713"> <ttl>How to Add Subtotals Using the GROUPING Function</ttl> <xreftext>“How to Add Subtotals Using the GROUPING Function”</xreftext> <div element="sect3" href="tdpdw_sql.htm" number="7.1.3.1" targetptr="TDPDW00722"> <ttl>When to Use the GROUPING Function</ttl> <xreftext>“When to Use the GROUPING Function”</xreftext> </div> <div element="sect3" href="tdpdw_sql.htm" number="7.1.3.2" targetptr="TDPDW00723"> <ttl>Example: Using the GROUPING Function</ttl> <xreftext>“Example: Using the GROUPING Function”</xreftext> <obj element="bridgehead" href="tdpdw_sql.htm" number="" targetptr=""> <ttl>To use the GROUPING function:</ttl> <xreftext>“To use the <code>GROUPING</code> function:”</xreftext> </obj> </div> </div> <div element="sect2" href="tdpdw_sql.htm" number="7.1.4" targetptr="TDPDW00714"> <ttl>How to Combine Aggregates Using the GROUPING SETS Function</ttl> <xreftext>“How to Combine Aggregates Using the GROUPING SETS Function”</xreftext> <div element="sect3" href="tdpdw_sql.htm" number="7.1.4.1" targetptr="TDPDW00724"> <ttl>When to Use the GROUPING SETS Function</ttl> <xreftext>“When to Use the GROUPING SETS Function”</xreftext> </div> <div element="sect3" href="tdpdw_sql.htm" number="7.1.4.2" targetptr="TDPDW00725"> <ttl>Example: Using the GROUPING SETS Function</ttl> <xreftext>“Example: Using the GROUPING SETS Function”</xreftext> <obj element="bridgehead" href="tdpdw_sql.htm" number="" targetptr=""> <ttl>To use the GROUPING SETS function:</ttl> <xreftext>“To use the <code>GROUPING</code> <code>SETS</code> function:”</xreftext> </obj> </div> </div> <div element="sect2" href="tdpdw_sql.htm" number="7.1.5" targetptr="TDPDW00715"> <ttl>How to Calculate Rankings Using the RANK Function</ttl> <xreftext>“How to Calculate Rankings Using the RANK Function”</xreftext> <div element="sect3" href="tdpdw_sql.htm" number="7.1.5.1" targetptr="TDPDW00726"> <ttl>When to Use the RANK Function</ttl> <xreftext>“When to Use the RANK Function”</xreftext> </div> <div element="sect3" href="tdpdw_sql.htm" number="7.1.5.2" targetptr="TDPDW00727"> <ttl>Example: Using the RANK Function</ttl> <xreftext>“Example: Using the RANK Function”</xreftext> <obj element="bridgehead" href="tdpdw_sql.htm" number="" targetptr=""> <ttl>To use the RANK function:</ttl> <xreftext>“To use the <code>RANK</code> function:”</xreftext> </obj> </div> </div> <div element="sect2" href="tdpdw_sql.htm" number="7.1.6" targetptr="TDPDW00716"> <ttl>How to Calculate Relative Contributions to a Total</ttl> <xreftext>“How to Calculate Relative Contributions to a Total”</xreftext> <div element="sect3" href="tdpdw_sql.htm" number="7.1.6.1" targetptr="TDPDW00728"> <ttl>Example: Calculating Relative Contributions to a Total</ttl> <xreftext>“Example: Calculating Relative Contributions to a Total”</xreftext> <obj element="bridgehead" href="tdpdw_sql.htm" number="" targetptr=""> <ttl>To calculate relative contributions to a total:</ttl> <xreftext>“To calculate relative contributions to a total:”</xreftext> </obj> </div> </div> <div element="sect2" href="tdpdw_sql.htm" number="7.1.7" targetptr="TDPDW00717"> <ttl>How to Perform Interrow Calculations with Window Functions</ttl> <xreftext>“How to Perform Interrow Calculations with Window Functions”</xreftext> <div element="sect3" href="tdpdw_sql.htm" number="7.1.7.1" targetptr="TDPDW00729"> <ttl>Example: Performing Interrow Calculations</ttl> <xreftext>“Example: Performing Interrow Calculations”</xreftext> <obj element="bridgehead" href="tdpdw_sql.htm" number="" targetptr=""> <ttl>To perform interrow calculations:</ttl> <xreftext>“To perform interrow calculations:”</xreftext> </obj> </div> </div> <div element="sect2" href="tdpdw_sql.htm" number="7.1.8" targetptr="TDPDW00718"> <ttl>How to Calculate a Moving Average Using a Window Function</ttl> <xreftext>“How to Calculate a Moving Average Using a Window Function”</xreftext> <div element="sect3" href="tdpdw_sql.htm" number="7.1.8.1" targetptr="TDPDW00730"> <ttl>Example: Calculating a Moving Average</ttl> <xreftext>“Example: Calculating a Moving Average”</xreftext> </div> </div> </div> <div element="sect1" href="tdpdw_sql.htm" number="7.2" targetptr="TDPDW0072"> <ttl>Use of Partition Outer Join to Handle Sparse Data</ttl> <xreftext>“Use of Partition Outer Join to Handle Sparse Data”</xreftext> <div element="sect2" href="tdpdw_sql.htm" number="7.2.1" targetptr="TDPDW00721"> <ttl>When to Use Partition Outer Join</ttl> <xreftext>“When to Use Partition Outer Join”</xreftext> </div> <div element="sect2" href="tdpdw_sql.htm" number="7.2.2" targetptr="TDPDW00736"> <ttl>Example: Using Partition Outer Join</ttl> <xreftext>“Example: Using Partition Outer Join”</xreftext> </div> </div> <div element="sect1" href="tdpdw_sql.htm" number="7.3" targetptr="TDPDW0073"> <ttl>Use of the WITH Clause to Simplify Business Queries</ttl> <xreftext>“Use of the WITH Clause to Simplify Business Queries”</xreftext> <div element="sect2" href="tdpdw_sql.htm" number="7.3.1" targetptr="TDPDW00731"> <ttl>When to Use the WITH Clause</ttl> <xreftext>“When to Use the WITH Clause”</xreftext> </div> <div element="sect2" href="tdpdw_sql.htm" number="7.3.2" targetptr="TDPDW00732"> <ttl>Example: Using the WITH Clause</ttl> <xreftext>“Example: Using the WITH Clause”</xreftext> </div> </div> </div> <div element="chapter" href="tdpdw_refresh.htm" number="8" targetptr="TDPDW00275"> <ttl>Refreshing a Data Warehouse</ttl> <xreftext>“Refreshing a Data Warehouse”</xreftext> <div element="sect1" href="tdpdw_refresh.htm" number="8.1" targetptr="TDPDW0103"> <ttl>About Refreshing Your Data Warehouse</ttl> <xreftext>“About Refreshing Your Data Warehouse”</xreftext> <div element="sect2" href="tdpdw_refresh.htm" number="8.1.1" targetptr="TDPDW01031"> <ttl>Example: Refreshing Your Data Warehouse</ttl> <xreftext>“Example: Refreshing Your Data Warehouse”</xreftext> <obj element="bridgehead" href="tdpdw_refresh.htm" number="" targetptr=""> <ttl>To refresh a materialized view:</ttl> <xreftext>“To refresh a materialized view:”</xreftext> </obj> </div> </div> <div element="sect1" href="tdpdw_refresh.htm" number="8.2" targetptr="TDPDW0104"> <ttl>Using Rolling Windows to Offload Data</ttl> <xreftext>“Using Rolling Windows to Offload Data”</xreftext> <div element="sect2" href="tdpdw_refresh.htm" number="8.2.1" targetptr="TDPDW01041"> <ttl>Example: Using a Rolling Window</ttl> <xreftext>“Example: Using a Rolling Window”</xreftext> <obj element="bridgehead" href="tdpdw_refresh.htm" number="" targetptr=""> <ttl>To use a rolling window:</ttl> <xreftext>“To use a rolling window:”</xreftext> </obj> </div> </div> </div> <div element="chapter" href="tdpdw_optimize.htm" number="9" targetptr="TDPDW011"> <ttl>Optimizing Data Warehouse Operations</ttl> <xreftext>“Optimizing Data Warehouse Operations”</xreftext> <div element="sect1" href="tdpdw_optimize.htm" number="9.1" targetptr="TDPDW00271"> <ttl>Avoiding System Overload</ttl> <xreftext>“Avoiding System Overload”</xreftext> <div element="sect2" href="tdpdw_optimize.htm" number="9.1.1" targetptr="TDPDW0091"> <ttl>Monitoring System Performance</ttl> <xreftext>“Monitoring System Performance”</xreftext> <div element="sect3" href="tdpdw_optimize.htm" number="9.1.1.1" targetptr="TDPDW00911"> <ttl>Monitoring Parallel Execution Performance</ttl> <xreftext>“Monitoring Parallel Execution Performance”</xreftext> <obj element="bridgehead" href="tdpdw_optimize.htm" number="" targetptr=""> <ttl>To monitor parallel execution performance:</ttl> <xreftext>“To monitor parallel execution performance:”</xreftext> </obj> </div> <div element="sect3" href="tdpdw_optimize.htm" number="9.1.1.2" targetptr="TDPDW00912"> <ttl>Monitoring I/O</ttl> <xreftext>“Monitoring I/O”</xreftext> <obj element="bridgehead" href="tdpdw_optimize.htm" number="" targetptr=""> <ttl>To monitor I/O performance:</ttl> <xreftext>“To monitor I/O performance:”</xreftext> </obj> </div> </div> <div element="sect2" href="tdpdw_optimize.htm" number="9.1.2" targetptr="TDPDW0092"> <ttl>Using Database Resource Manager</ttl> <xreftext>“Using Database Resource Manager”</xreftext> </div> </div> <div element="sect1" href="tdpdw_optimize.htm" number="9.2" targetptr="TDPDW0101"> <ttl>Optimizing the Use of Indexes and Materialized Views</ttl> <xreftext>“Optimizing the Use of Indexes and Materialized Views”</xreftext> <div element="sect2" href="tdpdw_optimize.htm" number="9.2.1" targetptr="TDPDW01011"> <ttl>Example: Optimizing Indexes and Materialized Views Using the SQL Access Advisor</ttl> <xreftext>“Example: Optimizing Indexes and Materialized Views Using the SQL Access Advisor”</xreftext> <obj element="bridgehead" href="tdpdw_optimize.htm" number="" targetptr=""> <ttl>To optimize an index and materialized view:</ttl> <xreftext>“To optimize an index and materialized view:”</xreftext> </obj> </div> </div> <div element="sect1" href="tdpdw_optimize.htm" number="9.3" targetptr="TDPDW0102"> <ttl>Optimizing Storage Requirements</ttl> <xreftext>“Optimizing Storage Requirements”</xreftext> <div element="sect2" href="tdpdw_optimize.htm" number="9.3.1" targetptr="TDPDW01021"> <ttl>Using Data Compression to Improve Storage</ttl> <xreftext>“Using Data Compression to Improve Storage”</xreftext> <obj element="bridgehead" href="tdpdw_optimize.htm" number="" targetptr=""> <ttl>To use data compression:</ttl> <xreftext>“To use data compression:”</xreftext> </obj> </div> </div> </div> <div element="chapter" href="tdpdw_perform.htm" number="10" targetptr="TDPDW008"> <ttl>Eliminating Performance Bottlenecks</ttl> <xreftext>“Eliminating Performance Bottlenecks”</xreftext> <div element="sect1" href="tdpdw_perform.htm" number="10.1" targetptr="TDPDW0081"> <ttl>Verifying That SQL Runs Efficiently</ttl> <xreftext>“Verifying That SQL Runs Efficiently”</xreftext> <div element="sect2" href="tdpdw_perform.htm" number="10.1.1" targetptr="TDPDW00811"> <ttl>Analyzing Optimizer Statistics</ttl> <xreftext>“Analyzing Optimizer Statistics”</xreftext> </div> <div element="sect2" href="tdpdw_perform.htm" number="10.1.2" targetptr="TDPDW00812"> <ttl>Analyzing an Execution Plan</ttl> <xreftext>“Analyzing an Execution Plan”</xreftext> <div element="sect3" href="tdpdw_perform.htm" number="10.1.2.1" targetptr="TDPDW00833"> <ttl>Example: Analyzing Explain Plan Output</ttl> <xreftext>“Example: Analyzing Explain Plan Output”</xreftext> <obj element="bridgehead" href="tdpdw_perform.htm" number="" targetptr=""> <ttl>To analyze EXPLAIN PLAN output:</ttl> <xreftext>“To analyze EXPLAIN PLAN output:”</xreftext> </obj> </div> </div> <div element="sect2" href="tdpdw_perform.htm" number="10.1.3" targetptr="TDPDW00813"> <ttl>Using Hints to Improve Data Warehouse Performance</ttl> <xreftext>“Using Hints to Improve Data Warehouse Performance”</xreftext> <div element="sect3" href="tdpdw_perform.htm" number="10.1.3.1" targetptr="TDPDW00835"> <ttl>Example: Using Hints to Improve Data Warehouse Performance</ttl> <xreftext>“Example: Using Hints to Improve Data Warehouse Performance”</xreftext> <obj element="bridgehead" href="tdpdw_perform.htm" number="" targetptr=""> <ttl>To use a hint to improve data warehouse performance:</ttl> <xreftext>“To use a hint to improve data warehouse performance:”</xreftext> </obj> </div> </div> <div element="sect2" href="tdpdw_perform.htm" number="10.1.4" targetptr="TDPDW00814"> <ttl>Using Advisors to Verify SQL Performance</ttl> <xreftext>“Using Advisors to Verify SQL Performance”</xreftext> <obj element="bridgehead" href="tdpdw_perform.htm" number="" targetptr="TDPDW00836"> <ttl>Example: Using the SQL Tuning Advisor to Verify SQL Performance</ttl> <xreftext>“Example: Using the SQL Tuning Advisor to Verify SQL Performance”</xreftext> </obj> </div> </div> <div element="sect1" href="tdpdw_perform.htm" number="10.2" targetptr="TDPDW0082"> <ttl>Improving Performance by Minimizing Resource Consumption</ttl> <xreftext>“Improving Performance by Minimizing Resource Consumption”</xreftext> <div element="sect2" href="tdpdw_perform.htm" number="10.2.1" targetptr="TDPDW00821"> <ttl>Improving Performance: Partitioning</ttl> <xreftext>“Improving Performance: Partitioning”</xreftext> <div element="sect3" href="tdpdw_perform.htm" number="10.2.1.1" targetptr="TDPDW00838"> <ttl>Improving Performance: Partition Pruning</ttl> <xreftext>“Improving Performance: Partition Pruning”</xreftext> </div> <div element="sect3" href="tdpdw_perform.htm" number="10.2.1.2" targetptr="TDPDW00851"> <ttl>Improving Performance: Partitionwise Joins</ttl> <xreftext>“Improving Performance: Partitionwise Joins”</xreftext> </div> <div element="sect3" href="tdpdw_perform.htm" number="10.2.1.3" targetptr="TDPDW00839"> <ttl>Example: Evaluating Partitioning with the SQL Access Advisor</ttl> <xreftext>“Example: Evaluating Partitioning with the SQL Access Advisor”</xreftext> </div> </div> <div element="sect2" href="tdpdw_perform.htm" number="10.2.2" targetptr="TDPDW00822"> <ttl>Improving Performance: Query Rewrite and Materialized Views</ttl> <xreftext>“Improving Performance: Query Rewrite and Materialized Views”</xreftext> </div> <div element="sect2" href="tdpdw_perform.htm" number="10.2.3" targetptr="TDPDW00823"> <ttl>Improving Performance: Indexes</ttl> <xreftext>“Improving Performance: Indexes”</xreftext> </div> <div element="sect2" href="tdpdw_perform.htm" number="10.2.4" targetptr="TDPDW12080"> <ttl>Improving Performance: Columnar Compression</ttl> <xreftext>“Improving Performance: Columnar Compression”</xreftext> <div element="sect3" href="tdpdw_perform.htm" number="10.2.4.1" targetptr="TDPDW12081"> <ttl>Improving Performance: DBMS_COMPRESSION Package</ttl> <xreftext>“Improving Performance: DBMS_COMPRESSION Package”</xreftext> </div> <div element="sect3" href="tdpdw_perform.htm" number="10.2.4.2" targetptr="TDPDW12082"> <ttl>Improving Performance: COMPRESS Clause of CREATE TABLE and ALTER TABLE</ttl> <xreftext>“Improving Performance: COMPRESS Clause of CREATE TABLE and ALTER TABLE”</xreftext> </div> </div> </div> <div element="sect1" href="tdpdw_perform.htm" number="10.3" targetptr="TDPDW0083"> <ttl>Using Resources Optimally</ttl> <xreftext>“Using Resources Optimally”</xreftext> <div element="sect2" href="tdpdw_perform.htm" number="10.3.1" targetptr="TDPDW00831"> <ttl>Optimizing Performance with Parallel Execution</ttl> <xreftext>“Optimizing Performance with Parallel Execution”</xreftext> <div element="sect3" href="tdpdw_perform.htm" number="10.3.1.1" targetptr="TDPDW00840"> <ttl>How Parallel Execution Works</ttl> <xreftext>“How Parallel Execution Works”</xreftext> </div> <div element="sect3" href="tdpdw_perform.htm" number="10.3.1.2" targetptr="TDPDW00841"> <ttl>Setting the Degree of Parallelism</ttl> <xreftext>“Setting the Degree of Parallelism”</xreftext> </div> <div element="sect3" href="tdpdw_perform.htm" number="10.3.1.3" targetptr="TDPDW00842"> <ttl>Example: Setting the Degree of Parallelism</ttl> <xreftext>“Example: Setting the Degree of Parallelism”</xreftext> <obj element="bridgehead" href="tdpdw_perform.htm" number="" targetptr=""> <ttl>To set the degree of parallelism:</ttl> <xreftext>“To set the degree of parallelism:”</xreftext> </obj> </div> </div> <div element="sect2" href="tdpdw_perform.htm" number="10.3.2" targetptr="TDPDW00832"> <ttl>About Wait Events</ttl> <xreftext>“About Wait Events”</xreftext> </div> </div> </div> <div element="chapter" href="tdpdw_bandr.htm" number="11" targetptr="TDPDW00274"> <ttl>Backing up and Recovering a Data Warehouse</ttl> <xreftext>“Backing up and Recovering a Data Warehouse”</xreftext> <div element="sect1" href="tdpdw_bandr.htm" number="11.1" targetptr="TDPDW0111"> <ttl>How Should I Handle Backup and Recovery for a Data Warehouse?</ttl> <xreftext>“How Should I Handle Backup and Recovery for a Data Warehouse?”</xreftext> </div> <div element="sect1" href="tdpdw_bandr.htm" number="11.2" targetptr="TDPDW0112"> <ttl>Strategies and Best Practices for Backup and Recovery</ttl> <xreftext>“Strategies and Best Practices for Backup and Recovery”</xreftext> <div element="sect2" href="tdpdw_bandr.htm" number="11.2.1" targetptr="TDPDW01121"> <ttl>Best Practice A: Use ARCHIVELOG Mode</ttl> <xreftext>“Best Practice A: Use ARCHIVELOG Mode”</xreftext> <div element="sect3" href="tdpdw_bandr.htm" number="11.2.1.1" targetptr="TDPDW01126"> <ttl>Is Downtime Acceptable?</ttl> <xreftext>“Is Downtime Acceptable?”</xreftext> </div> </div> <div element="sect2" href="tdpdw_bandr.htm" number="11.2.2" targetptr="TDPDW01122"> <ttl>Best Practice B: Use RMAN</ttl> <xreftext>“Best Practice B: Use RMAN”</xreftext> </div> <div element="sect2" href="tdpdw_bandr.htm" number="11.2.3" targetptr="TDPDW01123"> <ttl>Best Practice C: Use Read-Only Tablespaces</ttl> <xreftext>“Best Practice C: Use Read-Only Tablespaces”</xreftext> </div> <div element="sect2" href="tdpdw_bandr.htm" number="11.2.4" targetptr="TDPDW01124"> <ttl>Best Practice D: Plan for NOLOGGING Operations</ttl> <xreftext>“Best Practice D: Plan for NOLOGGING Operations”</xreftext> <div element="sect3" href="tdpdw_bandr.htm" number="11.2.4.1" targetptr="TDPDW01127"> <ttl>Extraction, Transformation, and Loading</ttl> <xreftext>“Extraction, Transformation, and Loading”</xreftext> <div element="sect4" href="tdpdw_bandr.htm" number="11.2.4.1.1" targetptr="TDPDW01128"> <ttl>The ETL Strategy and NOLOGGING Operations</ttl> <xreftext>“The ETL Strategy and NOLOGGING Operations”</xreftext> </div> <div element="sect4" href="tdpdw_bandr.htm" number="11.2.4.1.2" targetptr="TDPDW01129"> <ttl>Sizing the Block Change Tracking File</ttl> <xreftext>“Sizing the Block Change Tracking File”</xreftext> </div> </div> <div element="sect3" href="tdpdw_bandr.htm" number="11.2.4.2" targetptr="TDPDW01130"> <ttl>Incremental Backup</ttl> <xreftext>“Incremental Backup”</xreftext> <div element="sect4" href="tdpdw_bandr.htm" number="11.2.4.2.1" targetptr="TDPDW01131"> <ttl>The Incremental Approach</ttl> <xreftext>“The Incremental Approach”</xreftext> </div> </div> </div> <div element="sect2" href="tdpdw_bandr.htm" number="11.2.5" targetptr="TDPDW01125"> <ttl>Best Practice E: Not All Tablespaces are Equally Important</ttl> <xreftext>“Best Practice E: Not All Tablespaces are Equally Important”</xreftext> </div> </div> </div> <div element="chapter" href="tdpdw_security.htm" number="12" targetptr="TDPDW012"> <ttl>Securing a Data Warehouse</ttl> <xreftext>“Securing a Data Warehouse”</xreftext> <div element="sect1" href="tdpdw_security.htm" number="12.1" targetptr="TDPDW0121"> <ttl>Overview of Data Warehouse Security</ttl> <xreftext>“Overview of Data Warehouse Security”</xreftext> <div element="sect2" href="tdpdw_security.htm" number="12.1.1" targetptr="TDPDW01211"> <ttl>Why is Security Necessary for a Data Warehouse?</ttl> <xreftext>“Why is Security Necessary for a Data Warehouse?”</xreftext> </div> </div> <div element="sect1" href="tdpdw_security.htm" number="12.2" targetptr="TDPDW0122"> <ttl>Using Roles and Privileges for Data Warehouse Security</ttl> <xreftext>“Using Roles and Privileges for Data Warehouse Security”</xreftext> </div> <div element="sect1" href="tdpdw_security.htm" number="12.3" targetptr="TDPDW0123"> <ttl>Using Virtual Private Database in Data Warehouses</ttl> <xreftext>“Using Virtual Private Database in Data Warehouses”</xreftext> <div element="sect2" href="tdpdw_security.htm" number="12.3.1" targetptr="TDPDW01231"> <ttl>How Virtual Private Database Works</ttl> <xreftext>“How Virtual Private Database Works”</xreftext> </div> </div> <div element="sect1" href="tdpdw_security.htm" number="12.4" targetptr="TDPDW0124"> <ttl>Overview of Oracle Label Security</ttl> <xreftext>“Overview of Oracle Label Security”</xreftext> <div element="sect2" href="tdpdw_security.htm" number="12.4.1" targetptr="TDPDW01241"> <ttl>How Oracle Label Security Works</ttl> <xreftext>“How Oracle Label Security Works”</xreftext> </div> <div element="sect2" href="tdpdw_security.htm" number="12.4.2" targetptr="TDPDW01242"> <ttl>How Data Warehouses Benefit from Labels</ttl> <xreftext>“How Data Warehouses Benefit from Labels”</xreftext> </div> </div> <div element="sect1" href="tdpdw_security.htm" number="12.5" targetptr="TDPDW0125"> <ttl>Overview of Fine-Grained Auditing in Data Warehouses</ttl> <xreftext>“Overview of Fine-Grained Auditing in Data Warehouses”</xreftext> </div> <div element="sect1" href="tdpdw_security.htm" number="12.6" targetptr="TDPDW0126"> <ttl>Overview of Transparent Data Encryption in Data Warehouses</ttl> <xreftext>“Overview of Transparent Data Encryption in Data Warehouses”</xreftext> </div> </div> </div>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de