Building a structure of QVD layers
Designing and building ETL layers of QVDs can pay dividends as your use of QlikView grows.
Background
Always try to plan your use of database tables in advance. It's usually much better to start by devising your QVD layers from the outset than to create them later and then having to rework the applications you have already created. QVDs are extremely efficient; as soon as you have the requirement to read the same source data twice or more, one extraction to QVD and then reading (and if necessary, manipulating) a QVD multiple times is generally faster than reading the database table several times into each application that requires it.
How to do it
Consider these scenarios:
- Scenario 1: A QlikView application that reads six database tables and does some transformation on each of them
- Scenario 2: A QlikView application that reads six QVD files that require no transformation
If scenario 1 has a failure on the reading of the sixth table for some reason, it could...
