Chapter 3.1

Transformations in the End-State Architecture

Abstract

One of the essences of the end-state architecture is that transformations of data occur
repeatedly throughout the architecture. Although it may appear that data are static at any
one moment in time, over a long spectrum of time, data are anything but static. There are
many reasons for the transformations of data that occur.

Keywords

ETL; End state architecture; Transformation; Redundant data; Textual ETL;
Dimensional modelling; Corporate data; Application data; Bulk storage

When you take your first glance at the end-state data architecture, several things jump
out at you. One of those things is the need for transformation processes. There are a
variety of transformations that occur. There is textual ETL. There is ETL. There are data
marts that are created by using the techniques of dimensional data modeling. There is
refinement of bulk data, and so forth.

Redundant Data

One of the apparent by products of this transformation process is the creation (or
proliferation) of redundant data. A superficial glance at the end-state architecture
produces the conclusion that redundancy of data is to be found everywhere in the
architecture.

Fig. 3.1.1 shows the apparent proliferation of redundant data in the end-state data
architecture.

Chapter 3.1: Transformations in the End-State Architecture