| Data Warehouse Loading |
| Production Database |
|
|
|
|
|
|
|
|
|
|
|
|
| Ÿ | Benefits: |
||||||||||
| – | low overhead |
||||||||||
| – | automatic |
||||||||||
| transformation |
|||||||||||
| – | near real-time |
||||||||||
| loading of |
|||||||||||
| operation |
|||||||||||
| data stores |
|||||||||||
|
|
| Log-based |
|
| Capture |
|
| Stage |
| Propagation |
|
|
|
| User-defined |
||
| Apply |
||
| Staging Table or ODS |