Comparison of data loading strategy into QlikView
Using QVD files
There some advantages and disadvantages of using QVD files
- Same data for all users
- Loader QVS pulls data into memory and saves it into the file
- Additional processing on the QlikView server
- QVD’s can be generated only by QlikView
Using QVX files
Benefits of using QVX files
- Same data for all users
- Advanced ETL Processor data saves the data into the file without loading everything into the memory
- AETL can perform data transformation and validation on the fly
- Can automate file transfers via FTP/Emails/HTTP/File operations.
- Can work in a distributed environment