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.
The following conditions apply to an optimized load:
- Renaming a field is allowed.
- Data transformation is not allowed.
- You cannot add new fields.
- "where exists" on a single field is allowed. However,
Where Exists(EmpID,SalesID)is not allowed. - "where exists" is not allowed to rename ...
Get QlikView Essentials now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
