This section individually describes how to capture changes in the source table, including new source records, modified source records, and records that have been deleted from the source. The methods described can be combined to detect different types of data changes in one step.
In the case study scenario, the source database does not contain any change log information, so source and the target content must be compared to detect any changes. Since, in most cases, the source and target objects do not reside in the same database, a heterogeneous join needs to be performed.
