Tagged Questions
6
votes
3answers
165 views
Header and line item data source mismatch
I'm working with a star schema for a data warehouse and I am running into a problem with header and line items from different data sources.
CREATE TABLE DataSourceAHeader
(
OrderId INT NOT NULL
...
1
vote
1answer
79 views
Conceptual Design of a data warehouse (declaring the grain)
I am trying to design a data warehouse using this example scrubbed data. I need to declare the "grain". I know its the lowest level of detail in the fact table, but I am having a hard time determining ...
1
vote
2answers
137 views
Data warehouse support tickets
I'm starting to design a data warehouse for a company. The first questions we're trying to resolve are regarding their support ticketing system. My initial schema is as follows
Now one of the ...
2
votes
1answer
359 views
Does surrogate key assignment for a fact table require that the source data has natural keys?
Let's say I have a simple OLTP database with orders, products, and customers:
And from it, I am building a data mart with an orders fact table, product dimension, customer dimension, and date ...
3
votes
3answers
362 views
How do you roll up header-level values on a fact table with line-item granularity?
From what I've read, the recommended granularity for a fact table based on an order header / line item structure is at the line item level. In the process, any additive values that apply only to the ...
1
vote
1answer
544 views
Design of fact table(s) and dimensions tables for data warehouse
Hi i'm newbie in Datawarehousing, how would you model this in a Data Warehouse:
i wish design the Data Warehouse which give the answers of statistics relating to a baseball league
For players
in ...
1
vote
1answer
448 views
An advice to design a fact table with a scd as a dimension
I have a problem of conception and I would like to get your ideas on how I'll be able to do what I am aiming.
My goal is to create a datawarehouse, with three dimensions and one fact table so far.
...
