In this chapter, we will discuss some basic foundational concepts of the ODS - what it is, how it is used, and its role in a data warehouse architecture. Specifically, we will address the various layers of the architecture:
• The Interface Layer
• The Data Staging Layer
• The Data Profiling Layer
• The Data Cleansing Layer
• The Data Integration Layer
• The Export Layer.
We will delve into not only the architecture, but also into some simple examples of the various main processing components that stage, profile, cleanse, and deliver the data.
In subsequent chapters, we will expand on the logic, code, ...