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

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


Degenerate Dimension

3 posters

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

Degenerate Dimension Empty Degenerate Dimension

Post  breadbox008 Wed Jul 10, 2013 6:58 pm

Does a degenerate dimension have to be numbers? Can it be text like categories that come in on the fact?

breadbox008

Posts : 2
Join date : 2011-06-06

Back to top Go down

Degenerate Dimension Empty Re: Degenerate Dimension

Post  ngalemmo Wed Jul 10, 2013 9:14 pm

Yes. A degenerate dimension is anything that doesn't fit as a dimension itself. However, they should be used sparingly.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Degenerate Dimension Empty Re: Degenerate Dimension

Post  sachij3u Thu Jul 18, 2013 12:20 pm

Yes i agree, Although we have used it quite often (given the business requirement) to track last_transaction_datetime (coming from source system along with userids)
sachij3u
sachij3u

Posts : 19
Join date : 2013-07-11
Age : 42
Location : Herndon, VA

Back to top Go down

Degenerate Dimension Empty Re: Degenerate Dimension

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

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