Fact Tables
>
Create a detail or rollup/combined fact table
Create a detail or rollup/combined fact table
Create the fact table that you wish to partition in the normal way. You must create an update procedure but do not need to load any data. The process of creating the update procedure will also build any indexes for the fact table.