I have an ETL that produces an output where one of the columns is calculated using a formula. The output is generated using the "append" method and the input moved from being all time data to only L4D worth of data.
The problem I have is that, due to some business circumstances, I have to re-calculate that column but I cannot run it against the entire input DataSet anymore. To make it more interesting, the output DataSet / column pair are used on quite a few dashboards and I would like to prevent having to update all of them with a new DataSet.
Yes, I want to update the calculated column on the already existing output.
Is there any way you guys can think of that I can use to do this?