Star schema with multiple dimension tables

[sujit_nath]

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.

[asinha1991 · Accepted solution]

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

[jaibau1993]

Take a look into this Tech Brief

Jaime.