[solved]An explanation of sentence: Any descriptive attribute that takes on a single value in the presence of a fact table

View previous topic View next topic Go down

[solved]An explanation of sentence: Any descriptive attribute that takes on a single value in the presence of a fact table

Post  tsozgen on Sat Apr 18, 2015 5:23 am

Hi There;
I am reading the book, "The Data Warehose toolkit by Ralph Kimball and Margy Ross, Third Edition" and I have encountered a sentence below. Could you explain the sentence? I know fact table and dimension table, however, descriptive attribute is not clear in my mind.


Any descriptive attribute that takes on a single value in the presence of a fact table measurement event is a good candidate to be added to an existing dimension or be its own dimension.

Thanks in advance.


Last edited by tsozgen on Sun Apr 19, 2015 5:50 am; edited 1 time in total

tsozgen

Posts : 1
Join date : 2015-04-18
Location : Turkey

View user profile

Back to top Go down

Re: [solved]An explanation of sentence: Any descriptive attribute that takes on a single value in the presence of a fact table

Post  ngalemmo on Sat Apr 18, 2015 10:19 am

Attributes are columns in a dimension table and they are 'descriptive', meaning they describe the context of the fact event. So, any attribute is a 'descriptive attribute'.

All it is saying is attributes should be placed in dimension tables.
avatar
ngalemmo

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

View user profile http://aginity.com

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