Status Code vs Status Description

View previous topic View next topic Go down

Status Code vs Status Description

Post  vanamali on Tue Apr 29, 2014 8:22 am

Hello,

In dimensional modeling do we store Status code or Status description in the dimension. (e.g. Policy Status code 'POL', Description 'Policy').

Do we use mapping tables as separate tables?

Thank you

vanamali

Posts : 7
Join date : 2013-10-30

View user profile

Back to top Go down

RE:Status Code vs Status Description

Post  hkandpal on Tue Apr 29, 2014 12:00 pm

Hi,

you can store them in a dimension table, you can create a common dimn table (junk dimension) to store this type of information.

http://en.wikipedia.org/wiki/Dimension_(data_warehouse)


thanks

Himanshu

hkandpal

Posts : 113
Join date : 2010-08-16

View user profile

Back to top Go down

Re: Status Code vs Status Description

Post  vanamali on Tue Apr 29, 2014 12:18 pm

Sorry, my question was
In the policy dimension should I store the 'Policy Status ID' (with a separate status table that contains status id and status description) OR should I store the 'Policy Status Description'

vanamali

Posts : 7
Join date : 2013-10-30

View user profile

Back to top Go down

Re: Status Code vs Status Description

Post  nick_white on Tue Apr 29, 2014 1:34 pm

You should always store all attributes of an object in the dimension that models that object - so the answer to your question is you store the ID and the description in the Dimension
This is one of the key differences between a transactional model and a dimensional model. What you are describing is essentially a transactional model in 3NF - where the object is to reduce/eliminate redundant data, by putting descriptions in a separate table and referencing them with codes. However in a Dimensional model it is expected that data is heavily duplicated.

nick_white

Posts : 366
Join date : 2014-01-06
Location : London

View user profile

Back to top Go down

Re: Status Code vs Status Description

Post  vanamali on Tue Apr 29, 2014 3:01 pm

Thank you...I got my answer.

vanamali

Posts : 7
Join date : 2013-10-30

View user profile

Back to top Go down

Re: Status Code vs Status Description

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