O'Reilly logo

Data Architecture: A Primer for the Data Scientist by W.H. Inmon, Dan Linstedt

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

6.3

The Data Warehouse/Operational Environment Interface

Abstract

The primary interface mechanism between the data warehouse and operational systems is ETL. It is a transformational technology. One component of ETL processing is occasionally the ODS. ETL can feed the ODS as well, and the ODS can feed the data warehouse. On occasion, there is a staging area as data is passed from the operational environment into ETL. An important technology where there is transaction processing is that of CDC – changed data capture

Keywords

CDC
ODS
ETL
data warehouse
transformational technology
ELT
As interesting as the Big Data/existing systems interface is, it is not the only interface the data architect needs to know about. The other major interface ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required