Sample Header Ad - 728x90

Proper name for reference tables in OLTP

1 vote
1 answer
263 views
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?
Asked by Lamar (123 rep)
Jan 14, 2021, 08:14 AM
Last activity: Jan 14, 2021, 12:17 PM