Fig. 8.3.5 Transaction processing systems, changed data capture option.

Inline Transformation

Another alternative to the classical operational to data warehouse interface is that of the
inline transformation. In the inline transformation, the data that need to flow to the data
warehouse are captured and processed as part of online transaction processing.

Inline transformation is not used very often because the coding needs to be part of the
original coding specifications and because of the resource consumption that is required
during high-performance online transaction processing. In truth, most code for online
transaction processing is created before any one realizes that the results of online
transaction processing need to be reflected in the data warehouse environment.

However, on occasion, this option is seen.

Chapter 8.3: The Data Warehouse/Operational Environment Interface