New answers tagged naming-convention
These are often referred to as code tables. It is common that the primary key will be a short code which can be used as a foreign key in tables which use the data. Theses tables may contain additional information as required.
There is always at least something else you should also know and almost equally, always something else you should be consciously putting a stop to. Specifically in the context of data warehousing, which is a relatively fledgling sector, leveraging relatively new technologies. In regards to what I've seen in the real world, walking into a company for the ...
Top 50 recent answers are included