QlikView Data (QVD) files are used to extract and store data into and from QlikView. This means that whichever table you read, from whichever database, you can store it in the QVD format before or after any transformations you perform on the table. The special characteristics of this file type are: • It contains only one logical table. • It uses a special algorithm to compress the data, achieving compression rates of up to 90 percent, depending on the fields' cardinality of the underlying data. • When reading a QVD table file in QlikView, the loading speed is anywhere from 10 to 100 times faster than when loading from a database. When the table file is being read without applying any transformations, QlikView performs an optimized load (super-fast mode). One of the main advantages of using QVD files is that, once you have a QVD on your disk, the table can be exploited by more than one QlikView application. This reduces the load on the database server, and optimizes QlikView resources and development time. This process is called QVD staging and is discussed further in Chapter 12, Advanced Data Transformation.
If you want to change selection, open document below and click on "Move attachment"
pdf
owner:
ngras - (no access) - QlikView 11 for Developers [eBook].pdf, p111
Summary
status | not read | | reprioritisations | |
---|
last reprioritisation on | | | suggested re-reading day | |
---|
started reading on | | | finished reading on | |
---|
Details