• I never touch the data source if I don't have too. I would make the new fact with a copy of the existing dimensions plus the addition of the new dimensions. This is what they coin as your data mart (mini-data warehouse) that can be completely conformed/tailored to your new business needs and can also be repopulated in the event of rapture.

    Just my 2 cents.