topic Re: Large QVDs in QlikView

Large QVDs

Anonymous — Mon, 27 May 2013 01:15:04 GMT

I'm working on data-modelling very large QVDs, rest of them look fine but there's one set of QVDs (Distribution data) that si challenging. One QVD is generated for that every month and it's size is almost 300 MB. So far, there are about 15 of them. When I include those in the data model, the QVW becomes very large and takes so long to reload.

Is there a better approach to handle such a situation ?

Re: Large QVDs

er_mohit — Mon, 27 May 2013 05:37:46 GMT

the data which you want from this qvd with making primary key to another table then using left keep or right keep or inner keep to get possible records from this qvd

Tmp:

load A,

from table Tmp;

left keep

Data_300MB:

load A,

from Data_300MB;

hope it helps you

Re: Large QVDs

Mon, 27 May 2013 05:52:15 GMT

USE

LEFT KEEP

between both table.

Re: Large QVDs

Mon, 27 May 2013 06:03:48 GMT

HI,

For the better performance try to perform first Optimised load of the master Qvds ( Fact Table ).

Then try to use where exists() on the Dimension tables loaded after the fact table keeping the Primary key in the Exist() clause .

Regards

Yusuf