topic Re: Load data - from .txt files vs .qvd in QlikView

Load data - from .txt files vs .qvd

Wed, 29 Apr 2015 07:29:25 GMT

Hi!

Bit of a newbie but we are currently loading data from multiple .txt files. They are extracted from our DB2 at night and the loaded early in the morning in QV.

The largest file is about 2,4 GB (which contains basically all our sales transactions) and a couple of them around 5-600 MB.

My question is if we should consider loading the data into QVD instead. Not that we are really experiencing any performance issues (but if could be improved hey 🙂 )

Thanks for any pointers on this topic.

Erik Nordström

Re: Load data - from .txt files vs .qvd

Wed, 29 Apr 2015 07:35:01 GMT

As most. Should the data loaded into QVD. The files will be smaller, and indexed content, which will speed up loading into QlikView.

Re: Load data - from .txt files vs .qvd

jagan — Wed, 29 Apr 2015 07:37:06 GMT

Hi,

I think there is no need of loading data into QVD in the following scenarios

- If you are using data in only one Dashboard

- If you are not implementing the Incremental loading

In this scenarios you can directly load the data from text files itself, loading into QVDs and then loading into QVWs is time taking process.

Regards,

jagan.

Re: Load data - from .txt files vs .qvd

manideep78 — Wed, 29 Apr 2015 07:38:58 GMT

Hi Erik,

Reloading time can be reduced when data is pulled from qvds, than any other data sources.