Updating Monthly Actuals - Better Approach?
Does anyone have any experience or comments on these two approaches to the monthly process of loading actuals?
1. Clear all fact records for existing month. Load the file data as-is.
2. Keep existing fact records. Load the variance between current file and previous file (stored in a staging database)
Wouldn't the second approach be ideal since the process would only get faster towards the end of month? It would also generate fewer records. Generally, the file will produce about 90K records each month.