topic Re: Star schema with multiple dimension tables in QlikView

Star schema with multiple dimension tables

sujit_nath — Sat, 16 Nov 2024 02:22:26 GMT

I have more than two fact tables. How do i create star schema out of this. (This was asked to me by someone)

So, what are the possible ways to acheive a star schema.

Re: Star schema with multiple dimension tables

asinha1991 — Fri, 27 Sep 2019 07:26:50 GMT

well if you have two fact tables, then your only shot is

concatenate the fact tables into one table...

try to find out dependency and normalize the fact table. For example if you have city, state, country in the fact table then create new dimension with

Geo_Dim:

city, state, country, ID

and use the id in your concatenated fact table.. it all depends on what kind of data you have , this is just a general idea..sometimes you may even want to snowflake ..all depends on data model required

Re: Star schema with multiple dimension tables

jaibau1993 — Fri, 27 Sep 2019 10:19:47 GMT

Take a look into this Tech Brief

Jaime.