Connecting Multiple Fact Tables

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

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.

I am using Sql Server 2008 R2.

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.