Large QVDs

[Anonymous]

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 ?

[er_mohit]

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:

like

load A,

B

from table Tmp;

left keep

Data_300MB:

load A,

B,

C,

D

from Data_300MB;

hope it helps you

[#3]

USE

LEFT KEEP

between both table.

[#4]

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