Mastering QlikView

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:

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 ...