Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

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

3 posters

Go down

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

Post  Hemapr 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

Back to top Go down

 Is it a good idea to have a single STATUS table if we have to store multiple status in the data mart? Empty 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 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

Back to top Go down

 Is it a good idea to have a single STATUS table if we have to store multiple status in the data mart? Empty 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 Fri May 18, 2012 5:45 pm

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

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

Back to top Go down

 Is it a good idea to have a single STATUS table if we have to store multiple status in the data mart? Empty 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

Back to top

- Similar topics

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