Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Connecting Multiple Fact Tables

3 posters

Go down

Connecting Multiple Fact Tables Empty Connecting Multiple Fact Tables

Post  dhasan 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

Back to top Go down

Connecting Multiple Fact Tables Empty Re: Connecting Multiple Fact Tables

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Connecting Multiple Fact Tables Empty Re: Connecting Multiple Fact Tables

Post  dhasan Tue Oct 02, 2012 2:28 am

I am using Sql Server 2008 R2.

dhasan

Posts : 2
Join date : 2012-10-01

Back to top Go down

Connecting Multiple Fact Tables Empty Re: Connecting Multiple Fact Tables

Post  hang 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

Back to top Go down

Connecting Multiple Fact Tables Empty Re: Connecting Multiple Fact Tables

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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