Is it a good idea to have a single STATUS table if we have to store multiple status in the data mart?
3 posters
Page 1 of 1
Is it a good idea to have a single STATUS table if we have to store multiple status in the data mart?
We have a situation that we need to have different types of status tables like Alarm Status, Ticket status and so on. There are atleast 5 status tables that we need in the data mart. Each status table has < 10 rows.
So, is it a good idea to create these status as 5 different tables or create 1 single STATUS table and identify different status type with a Type column in the status table.
Here is the design with a single Status table:
Status
--------
Status_ID (PK)
Status_Type (Alarm/Ticket/Flash etc)
Status_Code (If its Alarm then code = High)
Question : Is it a good idea to have a single STATUS table if we have to store multiple status in the data mart?
So, is it a good idea to create these status as 5 different tables or create 1 single STATUS table and identify different status type with a Type column in the status table.
Here is the design with a single Status table:
Status
--------
Status_ID (PK)
Status_Type (Alarm/Ticket/Flash etc)
Status_Code (If its Alarm then code = High)
Question : Is it a good idea to have a single STATUS table if we have to store multiple status in the data mart?
Hemapr- Posts : 12
Join date : 2012-05-15
Re: Is it a good idea to have a single STATUS table if we have to store multiple status in the data mart?
No, I don't think it's good idea in DW modeling. You should either group low cardinality status into junk dimensions or leave them in their respective standalone lookup dimensions if cardinality is not low. By having a single generic dimesion, you don't gain anything but to have a confusing model.
hang- Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia
Re: Is it a good idea to have a single STATUS table if we have to store multiple status in the data mart?
Exactly. This is a bad idea in OLTP models as well as dimensional models.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Multiple Facts or Single Facts and Status Table?
» Status Code vs Status Description
» Data Mart/Dimensional Data Store Definition.
» how to design? Vehicle location status fact table
» Fast changing status transactional fact table
» Status Code vs Status Description
» Data Mart/Dimensional Data Store Definition.
» how to design? Vehicle location status fact table
» Fast changing status transactional fact table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum