Changed data capture (CDC, also known as delta processing) is the process of determining which data have changed in a database. The ability to ignore any unchanged data will improve the efficiency of processes such as ETL. Other advantages of changed data capture include: downtime elimination, resource reduction, and increased data timeliness.
DMExpress™ is the fastest, most reliable, and cost efficient enterprise data integration software.* It speeds applications and delivers information to business users when they need it. DMExpress performs changed data captures by using joins to match primary keys of records, then comparing the data to determine which records have been added, updated, and deleted. High Performance Join, a feature of the separately licensable ADM (Advanced Data Management) component, can improve changed data capture applications even further.
DMExpress matches the primary keys of records, and then compares the corresponding data to determine any changes.
* Based on actual comparisons against leading competitors, including Informatica, IBM DataStage, and others. Claims are based on results of specific tests and may vary depending on environment.
