O'Reilly logo

Mastering QlikView by Stephen Redmond

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

Using an ETL approach to create QVD data layers

We now know that there are very good reasons for adopting an ETL approach to loading data in QlikView. Now we need to learn how we should go about implementing the approach.

Each part—Extract, Transform, and Load—has its own set of recommendations because each part has a very different function.

Essentially, the approach looks like this:

Using an ETL approach to create QVD data layers

The approach can be explained as follows:

  1. Extract the data from data sources into QVDs.
  2. Transform the data from the initial QVDs into transformed fact tables and conformed dimensions.
  3. Load the transformed QVDs into the final applications.

The final two layers, the transformed ...

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