Oracle Audio Technologies Retail Data Warehouse 13 User Manuals

Table of Contents

• Contents

  5
• Preface

  7
  • Audience

    7
  • Related Documents

    7
  • Customer Support

    7
  • Review Patch Documentation

    7
  • Oracle Retail Documentation on the Oracle Technology Network

    7
  • Conventions

    8
• Preinstallation Tasks

  9
  • Implementation Capacity Planning

    10
  • Check Database Server Hardware Requirements

    10
  • Check Database Server Software Requirements

    11
  • Other Software Requirements for the Data Warehouse

    12
  • Check Client System Requirements

    12
  • Create UNIX User Accounts

    12
  • Create UNIX Directories

    12
  • Alter Directory Ownership and Privileges

    13
  • Copy Profiles for RDW User

    14
• Installation Tasks

  15
  • Establish Data Warehouse Partitioning Strategy

    15
  • Create the RDW Database and Tablespaces

    16
    • Create the Database as Follows

      16
    • Create RDW Tablespaces

      16
  • Load RDW Database

    17
    • Create RDW Schema Owners

      17
    • Create RDW Datamart-level tables

      17
    • Set up RDW User Permissions

      17
  • Configure RETL

    18
  • Data Population

    18
    • Populate Datamart Default Data

      19
    • Populate Time Dimension

      20
    • Populate Static Dimension Data

      22
  • Install Oracle Configuration Manager

    23
• Appendix: Development Database Schema Implementation

  25
• Appendix: RDW Code Tree

  27
• Appendix: Oracle 10g Database Creation Scripts

  29
• Appendix: Tablespace Creation Scripts

  33
• Appendix: Installation Order

  35