python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - dimensional-modeling

Should I use multiple fact tables for each grain or just aggregate from lowest grain?

Fairly new to data warehouse design and star schemas. We have designed a fact table which is storing various measures about Memberships, our grain is daily and some of the measures in this table are t...
test-img

Niall Nicholls

etl

data-warehouse

dimensional-modeling

star-schema

star-schema-datawarehouse

Votes: 0

Answers: 1

Latest Answer

Each DataMart will have its own "perspective", which may require an aggregated fact grain. Star schema modeling is a "top-down" process, where you start from a set of questions or ...
test-img

David Browne - Microsoft

Posts

Questions

Blogs

Jobs