Degenerate Dimension

View previous topic View next topic Go down

Degenerate Dimension

Post  breadbox008 on 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

View user profile

Back to top Go down

Re: Degenerate Dimension

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Degenerate Dimension

Post  sachij3u on 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)
avatar
sachij3u

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

View user profile

Back to top Go down

Re: Degenerate Dimension

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