In not-SQL, you wouldn't want the "1" in there ... issue here is whether you should have an artificial ID in that lookup table at all. If your descriptions are unique and mostly static, dropping ...

While on a superficial level there are similarities between dimension tables and more normalized look up or reference tables, fundamentally these two concepts are separate things. Dimensions will ...