Right on

I don't particularly like the term "junk dimension", but that's how Kimball coined it back in the day. Here's the official reference(s) for anyone stumbling across this thread:

It's "junk dimension"

Bridge/Helper tables are also commonly used in dimensional modeling to address M:M relationships, but not the same as a "junk dimension".

A factless fact table would probably not be a feasible solution, because the purpose of the junk dimension is to take degenerate dimension values with low cardinality and place it...

It would really depend on the specific use-case. Can you provide some examples of the contents of your junk dimension?

It would be pretty tricky to get it working like this, and would probably be more complex than you would like...in my opinion.

You can send data via an API request...

Not sure I understand why you would want to do that...can you elaborate on the use case? What problem are you trying to solve?

I think you're crossing lines with another post maybe.

It's impossible to comment whether your approach is a sensible way without the necessary context of what the design looks like and...

I personally don't like system-versioned tables because they require a datetime type, and you don't control the values that are being inserted. I prefer to do that myself with effective...

My personal preference is to land Dates (or Date/Time) fields as text (varchar) in the staging area if I don't trust the source...or if I anticipate possible conversion issues.

The pro...

(see latest post)

• This reply was modified 5 months, 1 week ago by  Martin Schoombee.

I haven't and can unfortunately not comment on it, but Joe is well-known and respected for his work with the Kimball Group. It would definitely not hurt to read his...

I wouldn't change any configuration properties unless I have a better understanding of the root cause. If the CPU is high, then it is likely due to either a refresh...

How do I track for changes in Cost/Price? Just add a trigger to Product[UnitPrice] and Purchase[UnitCost] and maybe call a stored procedure from the trigger to (1) find all...

• This reply was modified 9 months, 2 weeks ago by  Martin Schoombee.

I'm not sure about the detail in the physical book as it's been a while since I've read it, but here is the official on the Kimball website: https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/timespan-fact-table/

As you...

(While I'm at it, say I have a bunch of recurring business costs, like rent and gas and the like. I can sum those by quarter (say) and then...

• This reply was modified 9 months, 3 weeks ago by  Martin Schoombee.