With the help of the CRUDhelper framework you can keep your QVD files in shape.
You can perform Create, Read, Update and Delete (CRUD) actions with ease.
Incremental loads (and of course full loads) will become very easy now.
All CRUD actions are time stamped and affected rows will be counted.
This way you can monitor your ETL-process in great detail.
The metadata is saved in a batch control file.
This file also contains the parameters for the next incremental load.
The CRUDhelper helps you with:
- Backing up the old QVD file.
- Counting the number of valid rows in the source.
- Reading the (new or updated) source data.
- Creating new rows and updating existing rows.
- Deleting invalid rows.
- Rebuilding the data if an incremental load fails.
- Storing the data to the QVD file.
In this document you will find the QVW file and a PDF file.
The PDF file will get you started in minutes.
If you have ideas, questions or remarks please let me know.