QVW Data storage question

[chiru_thota]

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 ) ?

                                        Or

Separate Mapping table for each table ?

Thanks,

Chiru

[Gysbert_Wassenaar]

See this blog post: Symbol Tables and Bit-Stuffed Pointers

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

[chiru_thota]

Thanks Gysbert,

It answered all my questions related to QVW storage.

Thanks,

Chiru.