Contents

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Documentation Accessibility
• Customer Support
• Review Patch Documentation
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Retail Documentation on the Oracle Technology Network
• Conventions

1 Introduction

• Business Intelligence and Retail Insights

2 Retail Insights Architecture

• Technical Architecture
  • ODI Master and Work Repository
  • Retail Insights Staging Area
  • Retail Insights Data Mart
  • Retail Insights Data Mining Schema
  • Logical Model

3 Dimension Data Concepts

• Retail Insights Dimension Processing Overview
  • Dimensions
  • Slowly Changing Dimensions
    • SCD Type 2
    • SCD Type 1
• Actions During Processing
  • System Columns in the Data Warehouse Tables
• Business Keys and Surrogate Keys
  • As-was, As-is and Point-In-Time Reporting
    • As Was Reporting
    • As Is Reporting
    • Point-In-Time (PIT) Reporting
  • Pushdowns
• Retail Insights Dimension Processing Flows Overview
  • SCD Type 2 Dimensions
  • SCD Type 1 Dimensions
• Dimensions Not Requiring SCD Behavior

4 Fact Data Concepts

• Retail Insights Fact Processing Overview
• Fact Functional Areas
• Fact Table Types: Base and Aggregate
  • Base Facts
  • Fact Aggregation
    • Positional Fact Aggregation
• Fact Temp Table Usage
  • Standard Fact Aggregations
  • As Is Aggregates

5 Retail Insights Program Overview

• Program Features
  • Program Return Code
  • Restart and Recovery
  • Message Logging
    • Daily Log File
    • Format
  • Program Error File
  • Multi-threading
    • Setting Up ETL_THREAD_VAL for Non-Oracle Retail Customers
• The First Time Retail Insights Batch is Run
  • Typical etlrefreshgenplp.ksh Run
• Typical Run and Debugging Situations
  • Retail Insights Dimension Load
  • Retail Insights Base Fact Load with Multi-threading
  • Retail Insights Partitioning Strategy
  • Retail Insights Knowledge Modules

6 ODI Program Dependency

• Batch Scheduling
  • Setting Up the Batch Schedule
    • Scheduling As Is Aggregate ETL Programs in the Batch Scheduler
• Extract, Transform, Load Dependencies

7 Program Reference Lists

• Known Issues
• Program Reference List

A Appendix: Application Programming Interface (API)

• Standards Common to all APIs
• API Table List

B Retail Insights Attributes and Physical Mappings

• Attributes and Physical Mappings List

C Appendix: Non-Retail Insights Columns

D Appendix: Retail Insights Setup Table Column Descriptions