Chapter 12. Enhancing the Data

When building data warehouse/business intelligence solutions, it is normal for data gaps to be present. These are typically key pieces of information required to match information or perform some analysis, or could be as simple as updating descriptive information. Enhancing the source application is often not an option due to cost, and/or limitations in the application.

The data gaps are normally fixed through manual processes that involve submitting requests for data modifications within the data warehouse/business intelligence environment, or building an application to enable users to manage their own data gaps. The following recipes will help you automate the process of enhancing the data within the data warehouse:

• Creating your application schema

• Creating your application tables

• Developing the journal tables to track changes

• Defining the audit triggers

• Defining the APEX Upload application

• Creating the Upload interface

Introduction

In a business intelligence and...