data modeling

[arulsettu]

Hi,

     i am having around 10 transactional(fact) table in my DB. and many other master(dimensional) table. to form schema what is the best way either can i concatenate all transaction tables or any other way?

please suggest some advice

thanks

[vinay_hg]

yes.. if star schema is possible go ahead with that.

[avinashelite]

Hi Arul,

*If your having same columns in all the tables then concatenation will be good.

*If you don't have common columns then don't go with the concatenation, go with join .

[mukesh24]

Hi ,

If u go for stars schema then u face performance issue.(Depend on u r datasize)

Regards,

Mukesh Chaudhari

[arulsettu]

Hi Avinash,

each table having common relation fileds

[#6]

Hi Arul,

* If your Fact Tables having Same Field Names and data then you go for Concatenation, it is better..

* If You are not Having Same data then you go for Link Table and performance wise better even though it is not Start Schema ...

[avinashelite]

Hi Arul,

Then you can concatenate those 10 transaction  tables  by renaming the fields and using other tables build the data models. This will work fine

[arulsettu]

Hi Avinash,

          the database size is little bit huge so it wont be a problem

[avinashelite]

no, if the 10 tables have same number of columns and same columns then it will be no issues