topic Re: datamodel in QlikView

datamodel

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I wanted to know what are the best practices If we have two or more fact tables in data model.??

Which is based on the data or any standard practices we need to follow??

Is there any such cases to have(two or more fact tables) in data model??

Explain briefly if any ideas!!!

Please help on this.

Re: datamodel

oscar_ortiz — Fri, 06 May 2016 18:10:32 GMT

You may want to check out this link:

Concatenate vs Link Table

Re: datamodel

marcus_sommer — Sat, 07 May 2016 10:10:11 GMT

Best practice is to reduce the number of fact-tables by concatenating/joining/mapping the tables together. This approach is logically and technically most the easiest way and is also quite often from a performance point of view the best solution - but it will be depend on many factors which approach is the most suitable for your requirement.

- Marcus

Re: datamodel

HirisH_V7 — Sat, 07 May 2016 11:03:45 GMT

Hi,

Its two way,

Initially one centralized all transaction table with using (Concatenate,left join,or others) then link master tables.

and Further create more than one transaction table using key and link with master tables.

HTH,

Hirish

Re: datamodel

Anonymous — Sun, 08 May 2016 08:01:50 GMT

according to my knowledge to follow the steps basically in the qlikview.

to remove the synthetic keys

to follows star schema