determine grain by the physical realities of the data's source
2 posters
Page 1 of 1
determine grain by the physical realities of the data's source
hello
what does this sentence means in kimball book?
"The grain is determined by the physical realities of the data's source"
but I think grain determine by a business process not the data's source.
how do you think?
what does this sentence means in kimball book?
"The grain is determined by the physical realities of the data's source"
but I think grain determine by a business process not the data's source.
how do you think?
fahime- Posts : 8
Join date : 2013-11-14
Re: determine grain by the physical realities of the data's source
I think you should re-read Kimball's book to understand the grain concept and how to define it. Typically I store the data at the lowest grain regardless of the business process. This allow the most flexibility for reporting.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: determine grain by the physical realities of the data's source
OK, thanks
can you explain "The grain is determined by the physical realities of the data's source",
what does it mean?
can you explain "The grain is determined by the physical realities of the data's source",
what does it mean?
fahime- Posts : 8
Join date : 2013-11-14
Re: determine grain by the physical realities of the data's source
Sure, the data defines the grain. There is uniqueness in the data based on the columns. When building fact tables, store the lowest uniqueness since this always leaves the ability to aggregate later. Read the chapter on the grocery store. Data is stored at the product level but the business process may want reporting at the ticket level.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Tool to capture physical metadata, logical business model and relationship between the two?
» Modelling parent-child relationship source tables to Fact with correct grain
» Determine loyality of customer
» Physical Implementation of Data Marts Using Conformed Dimensions
» Enterprise Date Warehouse/Bus Architecture Physical Implementation
» Modelling parent-child relationship source tables to Fact with correct grain
» Determine loyality of customer
» Physical Implementation of Data Marts Using Conformed Dimensions
» Enterprise Date Warehouse/Bus Architecture Physical Implementation
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum