Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to create QVD from Redshift table. Table has 93 columns and 70m records. It is taking 2hrs of time. Is it possible to reduce the time.
Thanks
Anirban
You need a first to slice your table into smaller slices - most commonly are period-fields like years or yearmonth - and afterwards just to load the new/changed records with an incremental load-approach. Within the second half of the following posting you will find various examples on how to load data incremental and ensuring an optimized qvd-load with exists() on them:
Advanced topics for creating a qlik datamodel
- Marcus