Should you call it a junk dimension?
Datamarts, cubes, tabular models...they all present a dimensional model to the end user that is intuitive. At least, that should be the case. So no abbrevations in the dimensional model. Business users tend to prefer to see the data in the same way they speak about it. So a product is a product, not a dim_product.
So far, so good. Except what does a business user think when he sees a table called 'Dim_Junk'?
A junk dimension is a dimension that holds attributes together from various source systems that don't really belong in any single dimension. However, you still like to have them available for analysis. Kimball suggests that you put them all together in a 'junk' - dimension just for that reason.
Back to the question. How shall we name the junk dimension? We can make two distinctions:
- the name it has in the underlying table structure
- the name it has presented to the end user via views or another abstraction.
It would make sense to call it a junk dimension in 1 so the developer knows exactly what kind of dimension it is. The end user is best of with a more friendly name such as 'rest-dimension' or something else.
However, should we call it a junk dimension in any case? Even if the end users do not know the underlying table structure, would he like to hear developers talk about junk dimensions? Maybe it's time for a different name, even in the table structure.