Why We Don’t Truncate Dimensions and Facts During a Data Load
Every once in a while, I come across a data warehouse where the data load uses a full truncate and reload pattern to populate a fact or dimension. While it may not be the end of the world for a small table, it does concern me and I usually recommend to redesign the load. My… Continue reading Why We Don’t Truncate Dimensions and Facts During a Data Load