A dimension with only one attribute
2 posters
Page 1 of 1
A dimension with only one attribute
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
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
Re: A dimension with only one attribute
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
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
Similar topics
» Dimension Attribute or Fact Attribute
» Separate dimension or dimension attribute
» Dimension vs Attribute
» New attribute for dimension
» Date attribute in Dimension
» Separate dimension or dimension attribute
» Dimension vs Attribute
» New attribute for dimension
» Date attribute in Dimension
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum