[solved]An explanation of sentence: Any descriptive attribute that takes on a single value in the presence of a fact table
2 posters
Page 1 of 1
[solved]An explanation of sentence: Any descriptive attribute that takes on a single value in the presence of a fact table
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.
Thanks in advance.
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
Re: [solved]An explanation of sentence: Any descriptive attribute that takes on a single value in the presence of a fact table
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.
All it is saying is attributes should be placed in dimension tables.
Similar topics
» Single Attribute Dimensions - why not instead write textual attribute into Fact table?
» Descriptive Text in Fact table
» Descriptive Fields in Fact Table
» [SOLVED] SCD2 Dimension and Fact Table
» Single fact table vs multiple fact tables - what is the right way in a dimensional model?
» Descriptive Text in Fact table
» Descriptive Fields in Fact Table
» [SOLVED] SCD2 Dimension and Fact Table
» Single fact table vs multiple fact tables - what is the right way in a dimensional model?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum