Optimal ETL Processing � Changed Data Capture Strategy | DMReview

Soumendra Mohanty writes in Optimal ETL Processing � Changed Data Capture Strategy about the specifics involved in capturing changed data in operational applications. Doing so comes in two flavors - reading log files for deltas, or capturing changes within the source system (and database) itself. Soumendra writes about the specific methods to utilize, and how Informatica and Oracle (9i and up) offer CDC as a feature. Useful info when dealing with very large source systems.