Connecting Multiple Fact Tables

View previous topic View next topic Go down

Connecting Multiple Fact Tables

Post  dhasan on Mon Oct 01, 2012 4:27 am

Hi There,
I have created a star schema with one Fact table & 6 dimensions tables. The Fact table has 10 million records as of Now. The data in this Fact table will keep on increasing (Lets assume we will be adding 10 million records each year to it). In such situation will it be appropriate to create mutiple fact table with same schema for each year or it will be advisable to add the new records to the existing Fact table(Will this create any performance issues).

If you recommend to add the new records to separate table with similar schema then how will i link these Fact tables together in the cube.

Thanks

dhasan

Posts : 2
Join date : 2012-10-01

View user profile

Back to top Go down

Re: Connecting Multiple Fact Tables

Post  ngalemmo on Mon Oct 01, 2012 5:48 pm

What database system are you using? Most support partitioning which allows you to break a table up into smaller pieces but still appear as a single table from a query standpoint.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Connecting Multiple Fact Tables

Post  dhasan on Tue Oct 02, 2012 2:28 am

I am using Sql Server 2008 R2.

dhasan

Posts : 2
Join date : 2012-10-01

View user profile

Back to top Go down

Re: Connecting Multiple Fact Tables

Post  hang on Sun Oct 07, 2012 7:44 pm

You should be able to use SQL Server's table partitioning feature to patition the fact table, and it is the best practice to do so, as suggested by Ngalemmo.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

View user profile

Back to top Go down

Re: Connecting Multiple Fact Tables

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum