• Fact tables should stand alone. Dimensions can be shared between fact tables.

    Create a new fact table with all the information required for the new process. If necessary, seed it by copying the existing fact table history into it.

    This defines the difference between your Data Warehouse (where all the data is kept) and the Data-Mart (the data that the specific user requires in the format they require it)