Maybe you’ve heard of the concept of a junk dimension but what exactly is it and when should you use it? Patrick breaks down this dimensional modeling concept.
Junk Dimensions
https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/junk-dimension/
Design Tip #113 Creating, Using, and Maintaining Junk Dimensions
https://www.kimballgroup.com/2009/06/design-tip-113-creating-using-and-maintaining-junk-dimensions/
Sample Script:
https://github.com/guyinacube/demo-files/blob/master/video%20demos/Synapse/20230321%20-%20Junk%20Dimension.sql