staging tables IS a table used at final stop before loading the data warehouse.
The data is cleansed, integrated and nicely formatted, but the surrogate keys are not present. It is an ideal place for debugging.
I usually truncate the staging tables on every load, so that you only look at the data that is being loaded in the current run. Again, great for debugging.
No comments:
Post a Comment