Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

CRUDhelper framework - Incremental loads with ease

rverschuren
New Contributor II

CRUDhelper framework - Incremental loads with ease

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.

Best regards,

René Verschuren

Attachments
Comments
gilbertomedeiro
New Contributor III

Hi René

thanks for sharing your background in QV good practices! That's great! It's very useful, at least to me!

Thanks,

Gilberto

Version history
Revision #:
1 of 1
Last update:
‎11-15-2013 06:41 AM
Updated by: