Chapter 8. Ingest utility 123
8.2 Business value
Great Toque Outdoors currently has an OLTP database for transactional
processing and a data warehouse for business intelligence. Its present ETL
strategy involves regular, although infrequent, processes by which the data is
exported from its OLTP database, transformed with scripts, and imported into its
data warehouse with batch load operations.
This current model poses several immediate problems:
Batch load operations require a window of time when exclusive access to the
database is required, locking out other queries and database operations.
Because Great Toque Outdoors is a global enterprise, there is no such thing
as off-peak hours; there is always a region somewhere in the world that