Too Dim or not Too Dim
No i'm not talking about a new Harry Enfield sketch
about a posh bloke that's a bit thick, I 'm talking about tables in a warehouse.
Many people insist on naming tables DimCustomer, Dim Product etc and
FactOrderLine. What is the purpose of this, especially in a UDM model where
tables can easily be dimensions and facts. What happens then, should it be
DimFactOrder or should it be FactDimOrder, sounds like something from a Chinese
menu.
I for one don't like the idea of naming objects this way, if you don't know
what is in the Customer table then you shouldn't be touching it.
I wonder what silly names one could end up with.
DimLight, DimPle....
-