Hi,
I need to add a new derived field as an additional analyze by date. What is the best approach for data already in the fact table? Do I read the fact table, derive the new field, right out with same grain with the analyze by? There is a very large number of records in the DL, so i do not want to have to truncate and reload, or process through all the DL historical records.
what is the best practice?
