topic Re: QVW Data storage question in QlikView

QVW Data storage question

chiru_thota — Wed, 05 Feb 2014 17:40:04 GMT

Hi All,

I have read the attached PPT and I understand how data stored in QVW.

Basically it is a two level storage

Level 1 : Unique values for all columns

Level 2 : Mapping table with Pointers.

Now I have a question about Level 2.

Let us say we have one fact table and 4 dimension table in our data model QVW.

Now will we have only one mapping table for all the table ( 1 fact + 4 dimensions ) ?

Separate Mapping table for each table ?

Thanks,

Chiru

Gysbert_Wassenaar — Wed, 05 Feb 2014 17:45:55 GMT

Each field will get a symbol table of its own and there will be five tables with pointers to the symbol tables.

chiru_thota — Fri, 07 Feb 2014 23:09:50 GMT

Thanks Gysbert,

It answered all my questions related to QVW storage.

Thanks,

Chiru.