datamodel

[#1]

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.

[oscar_ortiz]

You may want to check out this link:

Concatenate vs Link Table

[marcus_sommer]

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

[HirisH_V7]

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

[Anonymous]

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

to remove the synthetic keys

to follows star schema