CHAPTER 11
Delta Data Management
Fortunately, much of data integration is a relatively simple case of transferring all the data from a source (whatever it may be) to a destination (hopefully SQL Server). The destination is cleared out before the load process, and the objective is to get the data from A to B accurately, completely, and in the shortest possible time. Yet this basic scenario will inevitably not match everybody’s requirements all of the time. When developing ETL solutions you may frequently be called upon to ensure that only changes in data are applied from the source to the destination. Detecting data changes, and only (re)loading ...
Get SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
