Is it a good idea to have a single STATUS table if we have to store multiple status in the data mart?

View previous topic View next topic Go down

Is it a good idea to have a single STATUS table if we have to store multiple status in the data mart?

Post  Hemapr on Thu May 17, 2012 11:16 am

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?

Hemapr

Posts : 12
Join date : 2012-05-15

View user profile

Back to top Go down

Re: Is it a good idea to have a single STATUS table if we have to store multiple status in the data mart?

Post  hang on Fri May 18, 2012 5:13 pm

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

View user profile

Back to top Go down

Re: Is it a good idea to have a single STATUS table if we have to store multiple status in the data mart?

Post  BoxesAndLines on Fri May 18, 2012 5:45 pm

Exactly. This is a bad idea in OLTP models as well as dimensional models.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Is it a good idea to have a single STATUS table if we have to store multiple status in the data mart?

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum