# Building a Kimball dimensional model with dbt

**URL:** <https://discourse.getdbt.com/t/building-a-kimball-dimensional-model-with-dbt/7940>\
**Category:** In-Depth Discussions\
**Tags:** devblog\
**Created:** [April 21, 2023, 1:57am UTC](https://discourse.getdbt.com/t/building-a-kimball-dimensional-model-with-dbt/7940 "2023-04-21T01:57:38Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Koen](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/koen/32/2815_2.png) [@Koen](https://discourse.getdbt.com/u/Koen)\
**Post date:** [August 2, 2023, 1:02pm UTC](https://discourse.getdbt.com/t/building-a-kimball-dimensional-model-with-dbt/7940/5 "2023-08-02T13:02:55Z")

</div>

Thank you, @jonathanneo, for your invaluable blog! It has been incredibly helpful during our transition from a traditional handcrafted DWH to dbt.

I have a question concerning the handling of missing records in dimensional tables. How would you suggest dealing with this situation?

Here are some related resources I found on the topic:

[Design Tip #43: Dealing With Nulls In The Dimensional Model](https://www.kimballgroup.com/2003/02/design-tip-43-dealing-with-nulls-in-the-dimensional-model/)  
[How do you deal with missing dimensions for foreign keys? - In-Depth Discussions - dbt Community Forum (getdbt.com)](https://discourse.getdbt.com/t/how-do-you-deal-with-missing-dimensions-for-foreign-keys/1274/5))

---

_[View the full topic](https://discourse.getdbt.com/t/building-a-kimball-dimensional-model-with-dbt/7940)._