Data Warehouse lookup patterns, Junk Dimensions — shall I use them?
On a previous article I referred most of ETL overhead is related to the data warehouse fact table record enrichment process. Indeed, what it does is mostly adding attributes to data so specific analysis can be…