Replace fields with new fields from another source
We currently have some fields that are defined by a virtual table.
We've decided to add these fields to our main fact table instead for performance reasons. As such, the current fields will become defunct
The fields are used in lots of reports so manually editing them to replace the old with the new is not really feasible.
Is there a faster way to replace/swap/switch the fields so that the new ones propagate to all the reports?