针对SCD(Slowly Changing Dimension), 每个ETL 工具,每种数据库,都有着自己的解决方法:
SSIS,前一篇文章写到有自己的data flow tranformation - Slowly Changing Dimension
SQL SERVER 2008 AND Oracle 10g以上,都有自己的CDC(Change Data Capture)
Informatica,也有着自己的mapping transformation component
接下来对oracle 的CDC做下学习,以下是笔记:
Oracle CDC 有2种类型,4种模式:
1. Synchronous CDC
2. Asynchronous CDC
2.1 Asynchronous CDC - Hotlog Mode
2.2 Asynchronous CDC - Distributed Hotlog Mode
2.3 Asynchronous CDC - AutoLog Mode
2.3.1 Asynchronous CDC - AutoLog Mode - Online option
2.3.2 Asynchronous CDC - AutoLog Mode - Archive option