I know this might be a silly question. But I really appreciate accepting and answering this question.
When I have an OLTP database with some big tables like orders and items. I have other tables (similar to dimension tables in OLAP) where we store reference values, such as: currency, city, category.
What is the proper name for those reference tables? Can we still call them dimension tables in OLTP or do they have their own generic name?