The following 14-min video shows how the Delta Tags technique easily replaces another commonly used approach to incremental loads (based on variables) in QlikView and Qlik Sense, and demonstrates why the Delta tags approach makes the process more reliable while still being highly efficient and configurable. Another important aspect of this technique that is demonstrated in the video is how the Delta Tags approach works very well with segmented QVDs (a.k.a partitioned QVDs) in an incremental scenario, something that is not as straightforward to implement with other approaches.
One of the major themes in last week’s Qonnections event in Dallas, TX, was the importance of having a solid Data Strategy in conjunction with a good Analytics Strategy to build and support a robust Data Platform that not only enables but also nurtures a Data Literacy culture within a company. This focus on the [...]
Delta Tags – A new mechanism for efficiently keeping track of incremental reloads in QlikView and Qlik Sense
When working with large datasets in QlikView and Qlik Sense, it’s important to ensure the backend data processing jobs (Extracts and Transforms) perform efficiently, by following best practices to reduce execution time and keep resource usage at a minimum. One of the best practices recommended for efficient data processing is implementing an incremental load strategy, [...]