Page 258 - Data Architecture

Chapter 6.5: Introduction to Data Vault Implementation

Fig. 6.5.1 Architectural changes and reengineering.

The design that is chosen by this team is to type it in by hand to a SQL prompt as “insert

into” statements.

Now, the parameters change:

Scenario #2: 1,000,000 rows of data, arriving every 24 hours, highly structured (tab
delimited, fixed number of columns). The requirement is to load the data warehouse in a

4-hour window. The question is as follows: can the team use the same “process design” in

258