Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Finding Information and Patches on My Oracle Support
• Finding Documentation on Oracle Technology Network
• Related Documents
• Conventions

1 Architecture

• Overview
• ETL Behavior
• Oracle Data Integrator Work Repository Artifacts
  • Execution Plans
  • Mappings
  • Variables
  • Sequences
  • User-defined Functions
  • Knowledge Modules
  • Models

2 Configuration Steps

• ETL Configuration
  • Configuring the C_LOAD_PARAM Table
  • Configuring C_LOAD_DE_IDENTIFY Attributes
  • Standard Configuration of the C_LOAD_DATES Table
  • Standard Configuration of the C_COHORT_PROCEDURE_TYPE Table
• Report Configuration
  • Customizing Reports Hierarchy

3 Executing ETLs

• Executing Full Load
• Executing Incremental Load
• Executing an Individual ETL
• Scheduling an ETL Execution Plan

A ETL Related Tables

• Mapping of Key System Attributes Between HDWF and CDM
• Configuring Code Types and Codes Used in ETL
• C_LOAD_DE_IDENTIFY Table

B Work Repository Artifacts

• Variables
• Sequences
• Interfaces

Index