topic Re: Qvd required in QlikView

Qvd required

qlikview979 — Mon, 20 Apr 2015 16:29:39 GMT

Hi friends

Why Qvd required ?!

Re: Qvd required

Mon, 20 Apr 2015 16:39:50 GMT

Simple Question..but difficult to answer.

QVD is Qlikview Proprietory Compressed Data File. You can load the raw Data and store it in compressed QVD file.

You can extract the data from the raw source, transform it and store it as QVD file.

Re: Qvd required

quwok — Mon, 20 Apr 2015 16:40:01 GMT

QVDs are not required, you can work with QlikView without ever touching QVDs.

QVDs are used to store the data exported from QlikView, and generally can help with the following scenarios

use as temporary store to increase load speed of data that do not change
reduce load on the database
extract once and use the data in multiple applications
implement incremental load

Re: Qvd required

prabhas277 — Mon, 20 Apr 2015 17:11:24 GMT

Hi,

1.Once the data is exported in QVD you don't have connect the database.The data will reside in the QVD.

2.Reading data from QVD is faster then reading from the data source.

3.incremental load can be implemented by using QVD

Regards,

prabhas

Re: Qvd required

maxgro — Mon, 20 Apr 2015 17:51:25 GMT

sometimes (better, often) you can't read all the data from the source (db, files, etc,.....) because the reload takes too long; storing data in qvd is a convenient way to reduce load window