can i take more than one fact table in one star.

[#1]

can i take more than one fact table in one star. plz give exaples friends

[Chanty4u]

hi babu,

Chk dis,

Re: Best practices for Data Modeling

[avinashelite]

I did not understand your question ....would you please elaborate more on your requirement

Star scheme will have 1 master fact table and rest of the dimension tables attached for that table..

[Gysbert_Wassenaar]

I don't think so. But perhaps concatenating the fact tables into one fact table is a solution that will work in your situation. Or maybe you can work with more than one star.

[HirisH_V7]

Hi,

Fact Table with Mixed Granularity

This May help You .

[jagan]

Hi,

The only option is you need to concatenate two fact tables into one if most of the columns are same in both the tables.

Regards,

Jagan.