Choosing a right Data Model

bhaskarsharma03 — Fri, 29 Nov 2013 17:10:50 GMT

Hi,

Can anyone help me in selecting the right data model.

Model 1. A Fact Table at the heart of the model and all dimensions connecting to it.

Model 2. A flattened Fact Table with most of the dimensions merged into it (wherever possible/feasible)

The second approach seems to give a more responsive UI. However is there any downside to it that I may have missed?

I have attached an image to explain this. Please note that the image is just an example, the real model contains almost a hundred dimension tables and has millions of rows of data in the Fact table, and some of the dimension tables.

I will appreciate if anyone can help me understand the advantages and disadvantages of both the approaches (keeping in mind the volume of data the model is supposed to hold).

Regards,

Bhaskar

Re: Choosing a right Data Model

Gysbert_Wassenaar — Fri, 29 Nov 2013 17:28:04 GMT

Have you read this document already: Joins and Lookups

The pdf's in this discussion may help too: Re: Performance Optimisation and Multiple Fact Tables

topic Re: Choosing a right Data Model in QlikView

Choosing a right Data Model

Re: Choosing a right Data Model