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

A dimension with only one attribute

2 posters

Go down

A dimension with only one attribute  Empty A dimension with only one attribute

Post  esreis Mon Apr 29, 2013 9:35 am

I need to sort the events of the fact table as "pending" or "finalized" and I plan to create a dimension to this situation.

example:
-------------
fatc_table
-------------
id_service
id_date
id_status
vlr_service

-----------
dim_status
-----------
id_status
status

Is correct to create a dimension with only one member?
In this case the information of the status field will only be:
1 - pending
2 - finalized

Thank you
Eduardo Reis

esreis

Posts : 3
Join date : 2013-04-29

Back to top Go down

A dimension with only one attribute  Empty Re: A dimension with only one attribute

Post  hkandpal Mon Apr 29, 2013 11:00 am

Hi,

one way you could create a Junk dimentsion where in you store low-cardinality flags and indicators of different types in one table.

http://www.kimballgroup.com/2009/06/03/design-tip-113-creating-using-and-maintaining-junk-dimensions/


thanks

Himanshu

hkandpal

Posts : 113
Join date : 2010-08-16

Back to top Go down

Back to top

- Similar topics

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