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
Chapter 6.5: Introduction to Data Vault Implementation