O'Reilly logo

QlikView Essentials by Chandraish Sinha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Optimized load – reading QVD

In the previous section, we have stored data into QVDs. Now it is time to read or load from a QVD. QVDs can be read as a regular load or as an optimized load.

An optimized load is a super-fast load that occurs if no transformations occur or certain conditions are applied. An optimized load is indicated by the message in the script progress window.

Optimized load – reading QVD

The following conditions apply to an optimized load:

  1. Renaming a field is allowed.
  2. Data transformation is not allowed.
  3. You cannot add new fields.
  4. "where exists" on a single field is allowed. However, Where Exists(EmpID,SalesID) is not allowed.
  5. "where exists" is not allowed to rename ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required