topic Re: Suggestion on Data Model in QlikView

Suggestion on Data Model

manojkulkarni — Thu, 21 Jan 2016 06:25:46 GMT

HI Friends,

I have multiple fact tables having date & Key field are common between them. Each table have 20+ columns with 10M records.

What is the best approach to handle ? I should be able to see data for any slicing and to a lowest granularity.

Please suggest

Re: Suggestion on Data Model

Anonymous — Thu, 21 Jan 2016 06:33:47 GMT

check these?

https://community.qlik.com/servlet/JiveServlet/previewBody/7343-102-1-9596/Best%20Practices%20in%20Data%20Modeling.pdf

Perfect Your QlikView Data Model

Best practices for Data Modeling

Best Practices in designing Data Model?

Re: Suggestion on Data Model

marcus_sommer — Thu, 21 Jan 2016 07:02:18 GMT

It's not enough information to give an advice. Did your application work in general? How is the performance?

- Marcus

Re: Suggestion on Data Model

manojkulkarni — Thu, 21 Jan 2016 07:12:45 GMT

HI Marcus

Still I haven't decided on Data Model. I am in initial stage of Data Model, so would like to get suggestion on how to handle multiple fact table ? Which one is better Concatenate or Linked Table when we have around 10M records per table..

Re: Suggestion on Data Model

Anonymous — Thu, 21 Jan 2016 07:23:58 GMT

Okay, check this?

http://stackoverflow.com/questions/18337272/handling-multiple-fact-tables-in-qlikview

How to handle multiple fact tables

Data Modelling With Multiple Fact Tables

Handling multiple fact tables...

Re: Suggestion on Data Model

marcus_sommer — Thu, 21 Jan 2016 07:23:58 GMT

I would rather try to reduce the number of fact-tables by joining, mapping and/or concatenate but it will depend on the data within your tables which method could be applied for which part of your tables. I assume you will need all of the above mentioned methods and if it's not possible/practicable to reduce it to one single table you will need a link-table between them - this meant a link-table between two large fact-tables is better then a or several link-table(s) between multiple fact-tables.

- Marcus

Re: Suggestion on Data Model

karthikeyan1504 — Thu, 21 Jan 2016 07:25:01 GMT

Hi Manoj,

The three tier architecture can be followed here as explained below.,

1. Extract the multiple fact tables and load it in separate qvds.

2. Concatenate the tables to make one fact table and store the second level of qvd which will act as one fact table.

3. Use the second level qvd for the dashboard.

Hope this helps!!!

Warm Regards,

Karthikeyan.

Re: Suggestion on Data Model

jagan — Thu, 21 Jan 2016 07:25:28 GMT

Hi,

If most of the fields are same then it is better to go with Concatenate with an additional flag to identify the datasource, if a less number of columns are same then go for Link table.

Regards,

jagan.