Incremental load is a very common task in relation to data bases. It is defined as loading nothing but new or changed records from the database. All other data should already be available, in one way or another. With QVD Files it is possible to perform incremental load in most cases. The basic process is described below:
The following basic cases can be identified:
1) Case 1: Append Only (typically log files)
2) Case 2: Insert Only (No Update or Delete)
3) Case 3: Insert and Update (No Delete)
4) Case 4: Insert, Update and Delete
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!