May 18, 2022
#3: In dimensional modeling, you can rebuild dimension tables without updating fact tables since the surrogate key is static. I created a dbt example project that highlights this and other techniques:
#3: In dimensional modeling, you can rebuild dimension tables without updating fact tables since the surrogate key is static. I created a dbt example project that highlights this and other techniques: